Data cleaning tricks in excel

[mohammadj.shamim]

There are many easy formulas to do so even in complicated datasets.

[nirmalasharma]

Wow, that's great to hear! What's amazing trick 👍

[INDIANAJONES_]

What should we do if data needs to be set in more than 2 columns

[harsinchh]

Sir,
A B C
20 40 30
(10) 50 [60
20 30 20
50 10 10
60 10 80
30 (90) 50]
20 20 70
From column A min value 10 to column b max value 90, how can I sum column c all cells from min value to max value at column A to column B.