LinkBack URL
About LinkBacks
please help me on this issue.
i need the larger data with date wise, sample file is attachedsample.png,
please help me on this issue.
i need the larger data with date wise, sample file is attachedsample.png,
Last edited by excelkira; 08-22-2019 at 03:13 AM.
Are you still using Excel 2007?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
In I3 then copy down
In J3 then copy across to Column K
Please Login or Register to view this content.
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Dear kvsrinivasamurthy ,
may be i am not able to understand to you , my requirement as per below, please help me.
sample again.JPG
Why not just use a pivot table?
Create a pivot table using range A2:C12 as your source data, then add Date in Filters, Symbol in Rows, Diff % in Values - then sort Symbol by Sum of Diff % Descending.
See attached example.
In A3 then dragged down.
=IF(B3="","",SUM(A2)+1)
ARRAY formula in B3 then dragged across and down.
=IFERROR(INDEX(K$4:K$13,SMALL(IF($J$4:$J$13=$C$1,ROW($K$4:$K$13),""),ROWS($B$3:B3))-ROW($J$4)+1),"")
With slight changes formula can be used in 2nd table. Pl see file.
How ARRAY formula is entered
Paste Formula in the cell.
Press F2
Hold Shift+ Ctrl Keys and hit Enter key.
Now the formula is surrounded by {} by excel.
Last edited by kvsrinivasamurthy; 08-23-2019 at 05:43 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks