S
Sandeep Jangra
D'all,
Can "if " search values in a list/range? If yes plz help with an example.
Can "if " search values in a list/range? If yes plz help with an example.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Stefi
You should give an example of the task!
Regards,
Stefi
„Sandeep Jangra†ezt Ãrta:
Regards,
Stefi
„Sandeep Jangra†ezt Ãrta:
S
Sandeep Jangra
Dear Stefi,
I have a list of names range A1:A7. Someone gave me a formula
=IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)). What does it mean $A$1:$A$7=$A$10.
I have a list of names range A1:A7. Someone gave me a formula
=IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)). What does it mean $A$1:$A$7=$A$10.
M
Max
Think its a good idea to start off the learning curve in Excel on the right
footing, eg learn the functionalities of Autofilter & Pivot table ahead of
complex array formulas. See my response to your other posting, where I've
provided you with the easy lead-in details on Autofilter & Pivot table.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
footing, eg learn the functionalities of Autofilter & Pivot table ahead of
complex array formulas. See my response to your other posting, where I've
provided you with the easy lead-in details on Autofilter & Pivot table.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
S
Stefi
The formula seems to be an array formula checking if name in A10 appears in
any of A1:A7. If yes it returns the row No, if not, it returns FALSE.
To try it select range B1:B7, enter formula and confirm it with
Ctrl+Shift+Enter!
Regards,
Stefi
„Sandeep Jangra†ezt Ãrta:
any of A1:A7. If yes it returns the row No, if not, it returns FALSE.
To try it select range B1:B7, enter formula and confirm it with
Ctrl+Shift+Enter!
Regards,
Stefi
„Sandeep Jangra†ezt Ãrta:
S
Sandeep Jangra
This is not returning row no. showing #value! in both A1:A7 and B1:B10. Plz
correct if any error in this.
correct if any error in this.