If Functions
Closed
kilown
Posts
2
Registration date
Friday 25 April 2014
Status
Member
Last seen
28 April 2014
-
25 Apr 2014 à 12:11
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 28 Apr 2014 à 10:39
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 28 Apr 2014 à 10:39
Related:
- If Functions
- How many if functions can be nested in excel - Guide
- Hard drive functions - Guide
- Spreadsheet functions - Guide
- Functions of wifi - Guide
- Excel functions in french - Guide
3 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
25 Apr 2014 à 12:28
25 Apr 2014 à 12:28
Kilown, Good afternoon.
Try to use it:
Select a cell where you need to have a first answer.
=IF(Site1!H2="y",Site1!G2,"")
Copy it down.
OK.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use it:
Select a cell where you need to have a first answer.
=IF(Site1!H2="y",Site1!G2,"")
Copy it down.
OK.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
kilown
Posts
2
Registration date
Friday 25 April 2014
Status
Member
Last seen
28 April 2014
28 Apr 2014 à 09:28
28 Apr 2014 à 09:28
Not really,
I have over 78 rows of info that i want to consoldate. meaning on "site1" there are 78 rows , i want to do is if box h7 has a Y then it will spit out the info on a different sheet , but if that box "h7" does not but H8" does then it will go to it, and so and so forth.
Also I want to make sure if to "if" functions are true ( H8 and h18 ) then H8 would populate on the new sheet lets say ( A2 ) and then H18 would sit on A3 .
I am using this for a tasking, saying if you have completed a task on this date , and its due in the next 30 days H7 would show a Y , and then if that Y is there, it will move over to a new sheet so I dont have to have people searching sheets it will be right on a single sheet and simple to read.
Jauhn S.
I have over 78 rows of info that i want to consoldate. meaning on "site1" there are 78 rows , i want to do is if box h7 has a Y then it will spit out the info on a different sheet , but if that box "h7" does not but H8" does then it will go to it, and so and so forth.
Also I want to make sure if to "if" functions are true ( H8 and h18 ) then H8 would populate on the new sheet lets say ( A2 ) and then H18 would sit on A3 .
I am using this for a tasking, saying if you have completed a task on this date , and its due in the next 30 days H7 would show a Y , and then if that Y is there, it will move over to a new sheet so I dont have to have people searching sheets it will be right on a single sheet and simple to read.
Jauhn S.
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
28 Apr 2014 à 10:39
28 Apr 2014 à 10:39
Jauhn S., Good morning.
Please, save an example of your work at a free site, www.speedyshare.com, and put a link to download here.
Place some data there and manually put a data like you expect to have when the formulas are ready.
It will be easier for everyone to understand and help you.
Have a nice day.
Please, save an example of your work at a free site, www.speedyshare.com, and put a link to download here.
Place some data there and manually put a data like you expect to have when the formulas are ready.
It will be easier for everyone to understand and help you.
Have a nice day.
