Hi there, I've been looking for a formula but I can't find one anywhere and I was hoping you could help.
I have text in Column A and I am trying to write a formula so that if HL is found in column A, then input 2 in Column B.
Can you help?
Thanks!
Hi there, I've been looking for a formula but I can't find one anywhere and I was hoping you could help.
I have text in Column A and I am trying to write a formula so that if HL is found in column A, then input 2 in Column B.
Can you help?
Thanks!
Do you mean?
=if(a2="hl",2,"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try this ..
Formula:Please Login or Register to view this content.
by asuming your data is in A2.. and drag downward..
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
How about:
Please Login or Register to view this content.
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
I don't think I've actually thought this through. I have 8 different options
X = 1
E = 2
H = 3
M=4
L=5
HL=6
W=7
ND=8
I'll just have to go down through them all!
Thanks anyways!
Is the text on it's own like "HL", or is it mixed with other text like "GTHLF"?
It's on it's own, but there are 202,500 cells with one of the eight options above in them, so I'm trying to save time!
Try this:
Please Login or Register to view this content.
That formula just changed the cells to 6, which doesn't correspond to my little code. Never mind guys, thanks for the help!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
It's not solved, but I'll figure something out, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks