Jump to content

How to input criteria in spreadsheet row of worksheet

Guest RMcK

Recommended Posts

I am trying to create a worksheet with multiple formulas in it. For this I need to be able to search different criteria in each column. The type is spaces. What is the order of the text I need to input into the cell to pick up with the criteria would do in a database row? I have looked through all of the following places and it is not very clear to a novice. 






Link to comment

Most of the worksheet functions can take criteria as a parameter when they are in worksheet cells even though they don't need criteria when in a database header.


=AREA in a database header might become  =Area(((L='1-Floor') & (C='Red'))) when in a worksheet cell.


Tell us more about what you are doing. Especially why you don't want to use a database and we might be able to give you better suggestions.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...