Extracting data from a column into another but sorted and with 2 related cells next to it

Purfleet · #2 08-22-2020, 11:49 PM

If i have read this right there are a few options, the old skool formula works but you need to be careful with how many rows are input and output and duplicates make it more complex.

Do a Small on the sales column =SMALL(Sheet1!$D$2:$D$5,ROWS($A$2:A2))
then index/match to bring back the serial and index numbers

Probably the easiest solution is to use pivot tables but you need to put the sorted column first, but then updating could be as easy as a refresh

Then we have the new dynamic arrays which i think are only in Excel 365, but they are very cool - Filter With a sort =FILTER(SORT(Sheet1!A2:E5,4,1),{1,1,0,1,0})

See attached

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extracting unique values from a list and sorted alphabetically	Marcia	Excel	2	10-13-2018 11:25 PM
eliminating blan rows between cells in a column cantaining data	FUGMAN	Excel Programming	6	03-01-2017 07:35 AM
Keeping the source format when extracting data from multiple cells using Vlookup function	praboos2001	Excel	6	11-15-2016 04:40 AM
Inserted Pictures from Local Data to cells column in excel	jessicakencana	Excel Programming	1	03-26-2016 03:51 AM
Lookup a value from non-sorted data	udea	Excel	12	04-25-2011 04:34 AM