Hi,
I have a spreadsheet attached that contains information in the first 5 columns as follows:
Date
Location
R
Type
R T
I need to return a number for each unique value, I have inserted a column with values in the attached in Col F as what I am trying to achieve.
Essentially, if the date, location, R and R T are the same (type does not matter at this stage), then it should return a number starting from 1 and increasing by 1 each time.
My sheet has many rows, with multiple dates, locations, R, Types and R T's, but attached is only a sample.
Hopefully this has explained what I am looking for, but if not please let me know.
I tried using SUMPRODUCT but could not get the desired result.
Bookmarks