Excel - U2 Feedback

Go Back   U2 Feedback > ZOOTV > Restart and Reboot Yourself
Click Here to Login
Reply
 
Thread Tools Search this Thread Display Modes
 
Old 08-25-2006, 12:14 AM   #1
ONE
love, blood, life
 
snowbunny00774's Avatar
 
Join Date: Nov 2004
Location: londonontario
Posts: 12,298
Local Time: 09:54 PM
Excel

If anyone is pretty good with Excel and will be around tmw (friday am EST) and wouldn't mind me picking your brain, can you PM me or leave me a msg here. One of my Q's is : Can I assign a numeric value to a letter? Basically I want to do an Info chart that I fill in with Y's or N's and then be able to convert those columns to a bar chart with the Y's & N's having a numeric value (expressed as a %) I assume this is pretty basic but I have just worked with numbers in Excel before and am not sure how I would do this. Wading through Help didn't enlighten me...
__________________

__________________
snowbunny00774 is offline   Reply With Quote
Old 08-25-2006, 01:30 AM   #2
Rock n' Roll Doggie
Band-aid
 
ntalwar's Avatar
 
Join Date: Feb 2004
Posts: 4,900
Local Time: 08:54 PM
Try the CODE() function.
E.g. CODE("Y")=89 and CODE("N")=78.
__________________

__________________
ntalwar is offline   Reply With Quote
Old 08-25-2006, 09:24 AM   #3
ONE
love, blood, life
 
snowbunny00774's Avatar
 
Join Date: Nov 2004
Location: londonontario
Posts: 12,298
Local Time: 09:54 PM
^ That helps a bit in that It's possible, but where do I enter the code, if I want the value of Y & N to be the same in all the cells? Help shows the same thing you've said but not where to enter it - If I try entering it in the cell then it just shows up..
__________________
snowbunny00774 is offline   Reply With Quote
Old 08-25-2006, 10:17 AM   #4
Rock n' Roll Doggie
Band-aid
 
ntalwar's Avatar
 
Join Date: Feb 2004
Posts: 4,900
Local Time: 08:54 PM
__________________
ntalwar is offline   Reply With Quote
Old 08-25-2006, 04:52 PM   #5
ONE
love, blood, life
 
snowbunny00774's Avatar
 
Join Date: Nov 2004
Location: londonontario
Posts: 12,298
Local Time: 09:54 PM
Thanks ntalwar.

I ended up using a different spreadsheet altogether, but out of curiosity, how would you reassign the value for Y or N as I see they are preassigned by my comp ( also, I want the value to remain hidden, and just be used in a formula that would show up in another spreadsheet which would be used to generate the graphs). Won't be using it now, but feel free to answer peeps as I may need it in future!
__________________
snowbunny00774 is offline   Reply With Quote
Old 08-25-2006, 05:57 PM   #6
Rock n' Roll Doggie
Band-aid
 
ntalwar's Avatar
 
Join Date: Feb 2004
Posts: 4,900
Local Time: 08:54 PM
For more complex stuff you'll probably need to write a VBA macro in the spreadsheet. You should be able to find code samples online for this. Loops and variables will probably be required.
__________________

__________________
ntalwar is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -5. The time now is 08:54 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Design, images and all things inclusive copyright © Interference.com