I have a table of NFL teams. Given the team I want to be able to place in a cell whether it's an AFC or NFC team. Does anyone know which function I can use to do this?
2006-08-05 14:22:01 · 5 answers · asked by King H 6 in Computers & Internet ➔ Programming & Design
Use the match function in combination with an IF statement
=IF(Match(textofwhatyou'relookingfor, tableyouaresearchingthrough,0), resulttrue, resultfalse)
2006-08-07 07:34:01 · answer #1 · answered by darkwing_5 2 · 0⤊ 0⤋
Excel doesn't know about football teams. At best you can look up that info on the web, put a 0 or a 1 code, and use a script to expand them into AFC or NFC.
2006-08-05 21:28:01 · answer #2 · answered by jacinablackbox 4 · 0⤊ 0⤋
I need a little more details to answer that question - do you mean you want Excel to automatically remember what an AFC or NFC team is?
2006-08-05 21:29:14 · answer #3 · answered by splath63 2 · 0⤊ 0⤋
Just guessing, because your question is vague, but wouldn't you use cut and paste? Highlight the cell that shows the team you want, hit "Ctrl + C" (to copy), then highlight the cell in which you want to place the picture, hit "Ctrl + V" (or just hit "Enter") and it will copy into the new cell. Hope this helps.
2006-08-05 21:29:15 · answer #4 · answered by Car Hop 2 · 0⤊ 0⤋
Sorry, I cant help you on this one. I usually hand write my stuff
2006-08-05 21:25:01 · answer #5 · answered by Mr.No-It-All 5 · 0⤊ 0⤋