How to compare a range of data in Excel?
Solved/Closed
shan_asa
Posts
7
Registration date
Sunday 29 October 2017
Status
Member
Last seen
5 December 2017
-
29 Oct 2017 à 09:53
shan_asa Posts 7 Registration date Sunday 29 October 2017 Status Member Last seen 5 December 2017 - 29 Oct 2017 à 14:01
shan_asa Posts 7 Registration date Sunday 29 October 2017 Status Member Last seen 5 December 2017 - 29 Oct 2017 à 14:01
Related:
- How to compare a range of data in Excel?
- Beyond compare - Download - File management
- How to copy data from one excel sheet to another - Guide
- How to merge and compare two excel files - Guide
- How to increase wifi range - Guide
- Export data from excel - Guide
2 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
29 Oct 2017 à 10:39
29 Oct 2017 à 10:39
shan_asa, Goodmorning.
Try to do:
D1 --> =IF(A1=$C$1, B1, "")
Copy it down as necessary.
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to do:
D1 --> =IF(A1=$C$1, B1, "")
Copy it down as necessary.
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
29 Oct 2017 à 13:25
29 Oct 2017 à 13:25
shan_asa,
I believe that this time it was possible to correctly understand your doubt.
Try to use:
=INDEX(B1:B6, MATCH(C1,A1:A6,0))
I hope it helps
--
Belo Horizonte, Brasil.
Marcílio Lobão
I believe that this time it was possible to correctly understand your doubt.
Try to use:
=INDEX(B1:B6, MATCH(C1,A1:A6,0))
I hope it helps
--
Belo Horizonte, Brasil.
Marcílio Lobão
shan_asa
Posts
7
Registration date
Sunday 29 October 2017
Status
Member
Last seen
5 December 2017
29 Oct 2017 à 14:01
29 Oct 2017 à 14:01
Thank you very much
Dat was awsom
Dat was awsom
29 Oct 2017 à 10:55
In the above formula u gave it is jus comparing A1 and C1. But what I require is the C1 value has to check A1 to A6 and then provide date to column D1. That is if C1 = A1 then D1 should be B1, if C1 = A2 then D1 should be B2 and so on.
Hope you understood what I want.