BostonBob
asked on
Data sorting to the correct rows
Hi All,
I have a situation where I am getting data downloaded into a spreadsheet and it is randomly downloaded but at least accurate data.
I want to be able to "sort" the data so that the data corresponds to the correct rows where I assign the tag for that specific row.
I have attached the spreadsheet to illustrate this. The downloaded data goes into the input tab. The Output tab is where i want the data to go into. So essentially when ever data appears in the input tab and/or adjusts I would like the same data to appear in the output tab but in the proper row. The sheet should make it clear.
Any help would be great.
thanks!
SortData.xlsx
I have a situation where I am getting data downloaded into a spreadsheet and it is randomly downloaded but at least accurate data.
I want to be able to "sort" the data so that the data corresponds to the correct rows where I assign the tag for that specific row.
I have attached the spreadsheet to illustrate this. The downloaded data goes into the input tab. The Output tab is where i want the data to go into. So essentially when ever data appears in the input tab and/or adjusts I would like the same data to appear in the output tab but in the proper row. The sheet should make it clear.
Any help would be great.
thanks!
SortData.xlsx
Please select all the data with header before sorting!
Enter this formula in A10 and copy down and across
=IF(AND(A$9<>"",$K10<>""), INDEX(Inpu t!$A$10:$I $1106,MATC H(Output!$ K10,Input! $A$10:$A$1 106,0),MAT CH(Output! A$9,Input! $A$9:$I$9, 0)),"")
=IF(AND(A$9<>"",$K10<>""),
ASKER
Thanks ssaqibh....almost there.
In the input section of the sheet the data is downloaded but then sometimes the data becomes old and is deleted....automatically. I guess this would be part of the "adjust" portion of my question. Adjust could mean more, less or none....
When I try this on your sheet I get an N/A answer in the cell when the input data is deleted away. Any quick fix on this?
Otherwise, super top marks for an elegant solution. I would have NEVER thought of doing it THAT way.
Thanks!
In the input section of the sheet the data is downloaded but then sometimes the data becomes old and is deleted....automatically. I guess this would be part of the "adjust" portion of my question. Adjust could mean more, less or none....
When I try this on your sheet I get an N/A answer in the cell when the input data is deleted away. Any quick fix on this?
Otherwise, super top marks for an elegant solution. I would have NEVER thought of doing it THAT way.
Thanks!
=IFERROR(IF(AND(A$9<>"",$K 10<>""),IN DEX(Input! $A$10:$I$1 106,MATCH( Output!$K1 0,Input!$A $10:$A$110 6,0),MATCH (Output!A$ 9,Input!$A $9:$I$9,0) ),""),"")
ASKER
SWEET. I wish I could give you 500,000 points! You saved me about 20 hours of groping in the darkness. So very, very awesome!!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yeah, you're right. i didn't even notice in my joy.
How can I reverse this and give YOU the points?
How can I reverse this and give YOU the points?
You have to click on the yellow triangle below the bottom right corner of the question where it says "Request Attention".
I think I have not contribute nothing!
Andrew
Andrew