Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My sheet could have anywhere from 1 to 200 rows.
A B C 1 Jones 9 8 2 Smith 3 3 Jones 6 6 4 Clark 4 3 5 Young 1 1 There's alot of other data in numerous sheets which gets summarized on one sheet. From this sheet I need to find the row numbers is C0 and B<C. The problem is I need a one line answer for the summary sheet (ex - The following rows have errors: 1, 4). Is there anyway to do this? Due to the way my data is compiled, I am unable to use Data Validation. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple cell references | Excel Worksheet Functions | |||
Function(s) that return multiple separated references | Excel Worksheet Functions | |||
I cant get Excel OFFSET Fnct to return multiple references. | Charts and Charting in Excel | |||
How do I put multiple references in the same cell? | Excel Worksheet Functions | |||
Return Cell References | Excel Worksheet Functions |