| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Formula results to specific row of matched criteria
hi Sam,
The first one is dynamic as is. For the second one, you could use: =IF(COUNTIF($A$1:A1,A1)<COUNTIF(A$:A$,A1),0,"Rest of your formula") to test the whole of column A. Not strictly dynamic, but it works much the same. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Sam via OfficeKB.com" <u4102@uwe wrote in message news:780333be1325a@uwe... Hi macropod, Thank you for reply and assistance. Apologies for delay in returning to Post. My data range is dynamic. Further help appreciated. macropod wrote: Hi Sam, Assuming your data are in column A1:A10, then the following formula in, say, B1 & copied down will cause your main formula's result to appear against the first occurrence only: =IF(COUNTIF($A$1:A1,A1)1,0,"Rest of your formula") and the following formula will cause your main formula's result to appear against the last occurrence only: =IF(COUNTIF($A$1:A1,A1)<COUNTIF(A$1:A$10,A1),0, "Rest of your formula") Can the above formula be modified to use a dynamic range, rather than fixed? Cheers, Sam -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Matched Numeric Labels across Single Row | Excel Worksheet Functions | |||
| Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
| Return Title to matched column | New Users to Excel | |||
| How to compare 2 lists and return un-matched? | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Threaded Mode
