| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List items based on the count given
Hopefully, this will help get started.
I lengthened columns A and B to test better for zeros. Update: Instead of "=A2" put this in E2: =IF(B2=0, INDEX(A:A,D2+2),A2) This takes care of the case when cell B2 contains 0. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count items based upon two separate values? | Excel Worksheet Functions | |||
| 2 conditions needed to check and count of items based on that | Excel Worksheet Functions | |||
| How to count and group items in a list depending on size of list? | Excel Programming | |||
| How to count items in a list and group depending on size of list? | Excel Programming | |||
| Count items on the list | Excel Discussion (Misc queries) | |||
![MyVeryOwnSelf[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
