Forum Discussion
kittysum
Aug 23, 2019Copper Contributor
Excel sorting cells with formula
Hi I got a question about Excel sorting. The function I used is Sort & Filter. Here is my setting - see below illustration: Column A - parameter input Column B-C - INDEX and MATCH function to ret...
kittysum
Aug 23, 2019Copper Contributor
IngeborgHawighorst Here's a sample document. I use $ sign for columns but not for rows because I have hundreds sets of data. If I used $ sign, I need to revise the formula in every row, right?
Thanks!
SergeiBaklan
Aug 23, 2019Diamond Contributor
In your List sheet remove reference on this sheet in formulas, i.e. use
=INDEX(Update!D:D, MATCH($C5, Update!$C:$C,0))
instead of
=INDEX(Update!D:D, MATCH(List!$C5, Update!$C:$C,0))
- kittysumAug 27, 2019Copper Contributor
- SergeiBaklanAug 27, 2019Diamond Contributor
kittysum , you are welcome