Feb 09 2020 08:29 AM
Hello community!!
I have a huge range of data. I need to put in red the MIN of each column. I can do this for one column. But how to do this for the whole range of data? (without doing it one column by one column of course)
thanks a lot for your help
best
hélène
Feb 09 2020 08:43 AM
Feb 09 2020 08:48 AM - edited Feb 09 2020 08:50 AM
Feb 09 2020 08:50 AM
Hi,
Select all columns, then create a new custom rule with this formula:
=A1=MIN(A:A)
Hope that helps
Feb 09 2020 08:55 AM - edited Feb 09 2020 08:59 AM
Feb 09 2020 08:55 AM
hello @Haytham Amairah
thanks for your quick answer.
I'm trying this right now.
at first, it seems like random results but I should be doing this wrong.
Trying again.
Feb 09 2020 09:05 AM - edited Feb 09 2020 09:14 AM
hello @Haytham Amairah
I know this looks trivial but could you describe step by step how you do this?
or with a small capture?
would be really nice
(do you use macro?)
:)
Feb 09 2020 09:07 AM
Feb 09 2020 09:21 AM - edited Feb 09 2020 09:24 AM
Solution
After you select the columns, just create a new rule with the formula.
If the columns start from B to H, then select only these columns and change the formula as follows:
=B1=MIN(B:B)
Feb 10 2020 05:33 AM
Nov 02 2020 02:45 AM
Hi,
I have several columns of data separated by columns of text and dates. I need to use the MIN function to process the data while ignoring the text and dates. =min(A1:A20) works as expected, but I cannot link multiple columns into the calculation. I would expect that something like =min((A1:A20),(D1:D20))
would work. Where do I go from here?
Thanks,
Bob.
Nov 02 2020 12:23 PM - edited Nov 02 2020 12:23 PM
Bob, that's separate question and better to start new conversation with it.
In brief, MIN() doesn't ignore dates which are internally integer numbers (e.g. 2 Nov 2020 = 44137), perhaps you other numbers are less than any date in the range.
Excel doesn't support union directly, as variant you may use =MIN(A1:A20,MIN(D1:D20))
Feb 09 2020 09:21 AM - edited Feb 09 2020 09:24 AM
Solution
After you select the columns, just create a new rule with the formula.
If the columns start from B to H, then select only these columns and change the formula as follows:
=B1=MIN(B:B)