Hi there. I need some help finding the next number but there's a twist. Attached is a file that shows what I need.
There's a sheet titled "Transactions" where the data is continually added to
and
the order cannot be changed so sorting the data is out of the question. The
next sheet is called "Need Formula" and this is where I need a formula to be
entered into cells H2 - H24 for this sample spreadsheet. The actual file will
have more rows.
The formula needs to look at the number in cell G2 and increment it by one
UNLESS, and here's the trick, there is already a number in this column (H) for
the combination of cells A2-C2 and F2. The sample will give you a better idea
as I've entered the end result in column H already. I just need a formula that
will give me the same result. Thank you so much for your help.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
next numbers.xls
Description: MS-Excel spreadsheet
