If Functions
Closed
kilown
Posts
2
Registration date
Friday April 25, 2014
Status
Member
Last seen
April 28, 2014
-
Apr 25, 2014 at 12:11 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Apr 28, 2014 at 10:39 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Apr 28, 2014 at 10:39 AM
Related:
- If Functions
- Accessor and mutator functions c++ - Guide
- What are the key functions of the supportassist for home pcs? - Download - Cleaning and optimization
- Excel functions in french - Guide
- Functions of spreadsheet - Guide
- How many if functions can be nested in excel - Guide
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 25, 2014 at 12:28 PM
Apr 25, 2014 at 12:28 PM
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 April 25, 2014
Status
Member
Last seen
April 28, 2014
Apr 28, 2014 at 09:28 AM
Apr 28, 2014 at 09:28 AM
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
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 28, 2014 at 10:39 AM
Apr 28, 2014 at 10:39 AM
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.
