Hello,
I have the following scenario:
* A sheet with several columns and rows. (2 of these columns will be important for the data I need to pull into a separate sheet with some formulas)
* Column 1 - Contains numbers (eg. 1.03, 2.54, 4.9, etc.) (Labeled by "TAT"))
* Column 2 - Contains text (eg. Desktop, Server, Other, etc.)
Data I Need in a separate sheet:
* Columns will be "Desktop", "Server", "Other"
* Rows will be 6+, 3-5, 2-3, 1-2, 0-1
*** I need the counts of each column for each of the different rows. For example, I need the count of "Desktop", where the TAT is 6 or more, between 3 and 5, between 2 and 3, etc.)
Can someone help?
Bookmarks