| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to number but skip blank rows
Hi, I am trying to number rows in column A using a formula. The numbering
should start with 150, not 1. The problem is that I only want the rows numbered if the values in column B are unique. When I say unique, any duplicate entries would be right on top of each other as shown below. The list is already sorted. Here is an example of what I would like the numbering to look like: A B 150 Apples 151 Oranges Oranges 152 Pears Pears Pears 153 Lemons 154 Limes Ive played around with formulas using IF and COUNTIF, but so far I havent had much success. I know this is probably simple, but so far I havent been able to figure it out. Thanks in advance for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy from one sheet to another and skip the blank rows | Excel Discussion (Misc queries) | |||
| Fill Cells with same number in three rows then skip to next number | Excel Worksheet Functions | |||
| Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
| Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
| skip blank rows when pasting formulas | Excel Worksheet Functions | |||
Threaded Mode
