hi
I want to extract one of the duplicate names in the table below, and add the numbers to each step. for example, James has been repeated in weeks 1 and 2 (cells d4 and d5 ) then in cell o4 once Is written james, and the numbers of each step are combined.The name of James is repeated again in cells D9 to D11. Thus, in the cell o5, the name of James is written again and the numbers of each step are summed up.
Please see attached
N4
=INDEX($C$4:$C$21,AGGREGATE(15,6,MATCH($C$4:$C$21,$C$4:$C$21,)/($C$4:$C$21<>$C$3:$C$20),ROWS(N$4:N4)))
thanks a lot
but How can I get the last column (numbers of the week)?
I have not opened the file, but the suggested formula is pulling from col C $C$4:$C$21
Adjust that so that it pulls from the column you want
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I could not do it. Please help me
Function textjoin is needed to do in 1 cell, which I don't have.
for difference cell,
Y4 press Ctrl+Shift+Enter drag to AF4 and drag down
=IFERROR(AGGREGATE(15,6,$B$4:$B$21/(IF($C$4:$C$21=$N4,$B$4:$B$21)** more in attached, Some how I can't post long formula
Last edited by Bo_Ry; 10-31-2018 at 12:01 AM. Reason: Attched wrong files
Sorry, sami204098
I attached wrong files, please download again from post #6
If the first column was used instead of the number of letters, for example one two three instead 1 2 3 , What should I do now?
Change $B$4:$B$21 to (ROW($B$4:$B$21)-ROW($B$3))
You can use Ctrl + H for replace at once, but still need Ctrl+Shift+Enter after replace
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks