Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
If I have a range, e.g. A1:A10, and in that range are various #'s, such as
1s, 2s, 3s or 4s. I'd like a formula in cell B1 that would produce all the DIFFERNT #'s that are in that range. i.e. If A1:A10 has only 1s in it, I'd like 1 in cell B1 If A1:A10 has 1s and 2s in it, I'd like 1,2 in cell B1 If A1:A10 has 1s,2s, and 3s in it, I'd like 1,2,3 in cell B1 If A1:A10 has 1s,2s, 3s, and 4s in it, I'd like 1,2,3,4 in cell B1 etc. The number of times each # is in the range is irrelevent. Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup specific value in a column and show it in a new cell | Excel Worksheet Functions | |||
Display characters present after a specific character | Excel Discussion (Misc queries) | |||
conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
show name when a cell has specific word | Excel Discussion (Misc queries) | |||
How do I show dates older than present date? | Excel Worksheet Functions |