Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
?
In Excel if I have a column of names and I want to display the Nth name where N is an integer variable, how do I do that?
In Excel if I have a column of names and I want to display the Nth name where N is an integer variable, how do I do that?
Specifically, lets say that the B column has Mary, Sue, Teresa, and Ana in boxes 1,2,3,4 and I have a number in C3 that would note which of the 4 I want to display, how can I display that cell s content?
Example above, if C3 is 3, then I should display "Teresa" if 1 then Mary.
While I could do this with a series of If statements, that gets clunky for long tables of names.
So what functions do I use?
Urls Welcome.
1 AnswerSoftware3 years agolinux and windows question. I have a directory that I can not delete. It shows up in a listing but not on a delete commmand.?
For Linux Mint, this shows the problem.
For windows it simply is still there when the delete command hits.
sean@Slaptop /media/sean/new 64g/xxjunk $ ls -abcFilNZ
ls: cannot access GOP & Dem and other politics.: No such file or directory
total 96
3638 drwx------ 4 sean sean ? 32768 Feb 17 20:04 ./
1 drwx------ 17 sean sean ? 32768 Feb 18 15:17 ../
? d????????? ? ? ? 0 ? ? GOP & Dem and other politics./
15196 drwx------ 3 sean sean ? 32768 Feb 17 20:04 xxFacebook FB photos/
sean@Slaptop /media/sean/new 64g/xxjunk $ cd ..
sean@Slaptop /media/sean/new 64g $ rm -rf xxjunk
rm: cannot remove ‘xxjunk/xxFacebook FB photos’: Directory not empty
sean@Slaptop /media/sean/new 64g $
3 AnswersOther - Hardware3 years agoTo start a writing business, how much? ( in San Bernardino County, Chino city?
Doing business as fees, publication fees, county business license fee, and likely others I do not know about.
How much to be doing business as a nom de plume in San Bernardino County?
Must I deal with Chino if I have the busines in my home and live there?
(In California)
2 AnswersSmall Business3 years agoEnglish question use of plural verb with 2 choices but one selection.?
Consider a sentence used in a discussion about the use of ‘nor’”
“Your choice is not ice cream nor cookies".
“Choices are”? Should I have said that when there is only one item to be chosen but two prohibited? “
3 AnswersWords & Wordplay3 years agoAre carbohydrates found in bread or sugar worst for diabetics?
If sugar is so bad, and my body says so, why is complex carbohydrates like those in bread or beer said to be worse for you than the stuff in fruit?
2 AnswersDiabetes3 years agoI am trying to find if there is a best sequence, and why. Is it I, my sister, and Melony or My sister, I and Melony or something else?
Is there a known and preferred way to list three people where one is using the pronoun 'I' for one of them?
2 AnswersLanguages4 years agoIs there a concept in Japanese of not wanting to marry people who have been near nuclear disaster?
Is there a concept in Japanese of not wanting to marry people who have been near nuclear disaster? Such as Abombs and the reactor disaster?
If so, does this have a name?
2 AnswersOther - News & Events4 years agoCat hit keys turn off monitor, what happened? try 3?
Twice my cat has walked across the keyboard and did something that turned the video output off. Monitor goes to sleep.
What could she be hitting and how to get things back?
Win 7 and Desk top
Dell Optiplex 745
No answer is no points.
Monitors4 years agoCat hit keys turn off monitor, what happened? try 2?
Twice my cat has walked across the keyboard and did something that turned the video output off. Monitor goes to sleep.
What could she be hitting and how to get things back?
Win 7 and standard flat computer.
1 AnswerMonitors4 years agoMilitary: how does the military handle two people with the same last name within a group?
1)Military: how does the military handle two people with the same last name within a group?
2)Can family serve together or is that rule still in effect?
3)Could you have twins in the same group?
Group being squad, platoon, etc any small enough that calling out last name would be not distinguishing enough.
And last name could be same without them being related. There are names ("Smith") that are common enough to make that a known and likely solved problem.
I want to know how they solved it, or would solve it.
5 AnswersMilitary4 years agoWhat marijuana product is best for essential tremors or Parkinsons? I live in CA?
My wife s mother s hands tremor.
I would like to get her something to stop this. I doubt she would use anything that gets her high or impairs thinking.
I have heard that MJ is good for such.
https://www.youtube.com/watch?v=rAdDdTZuNA8
What product would you recommend?
2 AnswersMedicine4 years agowhy do Caribbean island dish antennas point to the horizon not to space?
We just came back from a 2 week cruize.
Those islands that had dish antennas had most of them pointed to or near the horizon. One was pointed into a cliff side.
They are near the 18 or roughtly 20 degrees latitude mark, the antennas should be pointed up at 80 degrees.
Now the antenna horns were below, and that does give some angles, but not, in my opinion, enough.
3 AnswersTVs4 years agodo cats that are walked on leashes ever ask for awalk by bringing the leash?
3 AnswersCats5 years agoHow many districts in Zootopia?
How many Districts in Zootopia?
There are 4 that are big. There is one that is for small rodents.
But early on a number was mentioned. That number was bigger than 10. I just could not hear well to find what it was.
1 AnswerMathematics5 years agoHow may districts in Zootopia?
How may districts in Zootopia?
The number was mentioned only once near the start of the film.
3 AnswersMovies5 years agohow does vitreous humor taste?
How does vitreous humor taste?
My eye is very wet 3 days after surgery. How can I tell tears from v.h?
2 AnswersOptical5 years agoWhat smells do you associate with sorrow and why?
What smells do you associate with sorrow and why?
I have (am writing a story) a cartoon animal, a wolf, and she is very scent oriented. I need scents for her emotions, particularly as she uses scent-language for cussing and for telling her feelings.
Most examples wins when I return in a few hours. Wolf relevant works; human relevant works.
4 AnswersBooks & Authors5 years agoHeresy: Man's worship can power a god. What is this called?
IIRC, there is a heresy, maybe not a Christian one, that the god (lower case intened) is powered by man's worship.
This was use in Terry Pratchett's Small Gods, it has been used elsewhere. If you know what this is called, please tell me.
Earliers answer likely best, but most complete within a time frame will win.
4 AnswersReligion & Spirituality5 years ago