Get instant live expert help on how to create unique id in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Trying to create an unique ID in cell ROW G when the text "MIKS" in ROW B is present. Im working with logistics. When we have 2 small pallets, we usually stack them on top of eachother. I need to give those two the same unique ID.
Solved by I. S. in 17 mins
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 want to create a unique list in excel (like with the unique formula in excel online)
Solved by S. Y. in 15 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