Excel Magic Trick 471: Sort Horizontal With Formula 3 Examples

[Mrjustacabron]

Forget Batman...you are my hero now.

thank you very much

[ExcelIsFun]

You are welcome!

--Guy Having Fun With Excel Super Hero

[ExcelIsFun]

EXCELlent!!!!!

[moneycrab]

couldn't you just have selected the data, pressed copy and then gone somewhere in the sheet and done paste special> transpose and then sorted it vertically?

[ExcelIsFun]

Yes, but you would still have the problem of sorting each column separately. Each individual patient is a separate data set that needs to be sorted individually. This is not a data set that can have all the records sorted with one click. If it were though, you could avoid Copy and Transpose by using the horizontal sort feature (Sort Options button).

[secretarul]

I have a sheet with exactly the same structure like in this video.

But in cells i have 'Sumifs' formulas that take the arguments "Date1"(mine is Steelgrade) and "p1"(mine is Defectname).

The prob is that is kinda hard to sort them horizontally (or vertically, depends on what type of analisys) because the data is varying daily...

[ExcelIsFun]

You could use the OFFSET function to define a variable range. Here are some video titles that show OFFSET:

YTLE#105: Excel OFFSET for Dynamic Range in Function

Excel Dynamic Chart #10: OFFSET Function Dynamic Range

Excel Dynamic Chart #12: INDEX function as Alternative to OFFSET

The dynamic chart ones are the best to watch, but instad of using range in chart, use it in a function.

[secretarul]

Thank you !

I already implemented alotta of your teachings !

The latest one was the "Choose"

Choosin from sum to count it was a dailly activity for me, now it is more simpler ! :)

Thank for your kind work !

[ExcelIsFun]

You are welcome!

That is cool that you are now using CHOOSE to select from one of two functions!

[secretarul]

What if i have SumIfs formula instead of just dates ? How do i sort em ?

[ExcelIsFun]

I do not know. Can you explain in more detail about what you are trying to do?