| Author |
 Replies: 238 / Views: 8,102 |
|
|
|
Valued Member
Canada
287 Posts |
Quote:
deleting 10 currencies from your master list, Seriously? Row.Height=0 works good too and it is a lot easier to recover. Been there, done that. Edited by rikcando
08/07/2010 10:52 pm
|
|
Pillar of the Community
United States
2669 Posts |
You can also use MATCH to see if something is in a range.
|
|
Pillar of the Community
 United States
4000 Posts |
|
|
Pillar of the Community
United States
2669 Posts |
Quote:
Row.Height=0 haha.. yah I think I'll be doing that or hiding the row next time! |
|
Pillar of the Community
United States
4000 Posts |
Oh yeah, I forgot you were heading out there. Did you find a theme park for your dog?
|
|
Valued Member
Canada
287 Posts |
Quote:
You can also use MATCH to see if something is in a range. I changed the sheet Scooby sent me to use MATCH and it works the same only the formula is a bit shorter and easier to remember. =IF(ISNA(HLOOKUP(F6,$F$3:$Q$3,1,FALSE)),0,1) =IF(ISNA(MATCH(F6,$F$3:$Q$3,0)),0,1) |
|
Valued Member
United States
297 Posts |
im very confused about what you guys are talking about:0 is this like programming in excel?
|
|
Pillar of the Community
United States
4000 Posts |
They are just formulas. Did you get the spreadsheet I sent you?
|
|
Valued Member
United States
297 Posts |
oh I just checked my email, yep I got it thanks. :) I'm going to use it , thanks very much scooby due.
|
|
Valued Member
United States
297 Posts |
Wow I'm gonna try to use that to make something that could help me, thanks alot:) I knew you could make exel add cells for you and stuff but I didnt know just how much it could actually do
|
|
Pillar of the Community
United States
4000 Posts |
Save that as a master copy before you make any changes.
|
|
Pillar of the Community
United States
2669 Posts |
Quote:
Save that as a master copy before you make any changes.  Quote:
Did you find a theme park for your dog? Not yet - we were so disorganized and late leaving that I figured we'd do it on the way back. The kids also want to go Four Corners and a couple of other places, too, so we'll just make a wide swing north then east. |
|
Pillar of the Community
United States
4000 Posts |
Of course, you can also create a custom function. Mine looks like this: =IF(MASTERMIND(CURRENCY=INANSWER,  ,  )) |
|
Valued Member
United States
297 Posts |
i just tried opening it but I think I need excel 2010 to open it. Usually it converts it so I can read it like when rikcando made his in 2007 and emailed it to me my computer converted it so that I could use it with my 2003 version. I am going to open it tommorow with my parents computer which I think has 2010 or 2007. Thanks for the program and for all the help.
|
|
Pillar of the Community
United States
4000 Posts |
It should open with 2003. I don't even have 2007, much less 2010.
|
| |
Replies: 238 / Views: 8,102 |
First Page
Previous Page
Posted 08/07/2010 10:51 pm
