Get instant live expert help on I need help with excel unique id

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

On the Revenue Report/Tab, add a column labeled: Sum Paid. Formula =SUMIF([unique id column],[unique id cell in this row],[paid_amt column]) This will sum all payments for this unique ID into one place.
Solved by S. L. in 24 mins
I have 2 columns. Col 1 with text (Duplicate or Unique) and Col2 with ID no. I need formula to return the ID no. if Col 1 is "Unique". Please help.
Solved by T. S. in 12 mins
Complex VLOOKUP required looking for difference in timestamps and unique id
Solved by B. H. in 14 mins
On the Rev Tab, I need to add a column labeled: Sum Paid with Formula =SUMIF([unique id column],[unique id cell in this row],[paid_amt column]) This will sum all payments for this unique ID into one place. This is necessary to gather multiple payments entries into one cell entry.
Solved by A. F. in 19 mins
I have 4 columns (2lists) . 2 columns contain a unique ID that can be used to match up together. I need to copy the cell directly to the right of collumn 4 to each row that had the common unique ID. Currently have 2 lists BUG ID || Hours & BUG ID + TITLE || Category of work Need BUG ID || Hours || Category of work
Solved by O. E. in 30 mins