Forum Discussion
Tech Gurus I need your help.
Let's say your data are in A1:B6 on Sheet 1:
On the second sheet, enter this formula in A1:
=LET( Counts, 'Sheet 1'!A1:A6, Names, 'Sheet 1'!B1:B6, XLOOKUP(SEQUENCE(SUM(Counts)), SCAN(0, Counts, SUM), Names, , 1))
I have copied and pasted your solution and I changed the data to fit what I have on my sheet, however, I am getting a syntax error. Your solution makes more sense to me as there are multiple pages to this spread sheet and I am only looking to copy from page 1 to page 2 for my data. Any idea as to what this syntax would be as all I changed were Column and start/end information.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
I did send you a message. I have attached a snip of what I am getting.
I do not see a message from you in my PM inbox...