HOW TO: "If cell contains specific text display the immediate next word after it"
I have an excel file with each individual cell filled with data as it follows: Alejandro - GREEN Daniel - RED Sebastian - BLUE What I have been trying to do is to use a formula to extract the upper case value thats after the "-" immediate to the specific name of the person. At the moment I have the formula: =IF(COUNTIF(F3:F20,"*"&"Daniel"&"*"),"Yes","No") Which would simply return "Yes" if the cell contains the name Daniel, what I dont know how to do is to replace the "Yes" for a formula that would give me the "RED" in return. I know the formulas Left, Mid and Right are probably the way to go but since the separating character appears 3 times in a single cell (it being "-" I THINK) I have no idea how to stablish to use only the one after the specific name, and return only the very first word next to it (RED in case of Daniel). For this I have the formula =MID(M26,FIND("-",M26)+2,3) Which would give me GRE (3 characters only, dont know how to make it dynamic length) and would only return the very first entry as opposed to it being the one after the specific name, kinda close but no luck yet :/ Is this even possible? Edit: I attach my original file, I didnt before because the formula get so convoluted with other stuff I tried to keep it simple, basically its the formula on column O where i would replace the ":D" with the formula that im asking about.
I need a IFS statement for it to compare dates. If A2 less than 1 year then X If a2 more than 1 yea
need a statement that will look at a cell and determine the following less then 1 yr then put a 1 more than 1 less then 3 put a 2 more than 3 less then 4 put a 3 more than 4 less then 5 put a 4 more then 5 less then 6 put a 5 more than 6 less then 7 put a 6 more then 7 less then 8 put a 7 equal to or more then 8 put an 8
I need the Formual...
Hi there, I need the formulas for the blue and pink circle. Each of the highlighted fields are dances. If an X is placed in the cell that means the skater is dancing that particular dance and therefore the cost of that dance is $12. If they are skating more than one dance then for however many X's are in that row times 12 is what is to be calculated in the Blue circle. i need the formula for that . and essentially in the pink circle as well except that cost is $13 per dance. Can someone teach me how to write these formulas?
CHALLENGE
Ed Hansberry SergeiBaklan Please; Help me with this, which is a real challenge. On Sheet1 I have the distribution of hours on different days that last 2 activities for each group. There are some days that do not work (apart from Sundays). On Sheet2 I need two things: THE FIRST one that automatically calculates the percentage of progress of each group from the sum of hours from the start date to the current date (this is always changing). The second, that in SHEET2 show the non-working dates. I attached the file. Thank you all.
Formula needed to reorganize data
Hello, I'm a novice Excel user, but know basic formulas, but this need is stumping me. Need to find a formula to automate 100's of product image names based on the product SKU. I have a SKU number, imagename.jpg in 2 columns and need to have that list of individual SKUs in a new column with the corresponding images associated with that SKU. Each SKU has a different number of images. The image names have the SKU number in the name. I can Transpose the different SKUs in separate columns but I don't know how to set a formula to go to the next column once there is no more images with that SKU in the name. I was thinking this could be done with VLOOKUP, INDEX and MATCH and/or IF formulas as combined functions. IMAGE of what I'm trying to do: Actual Excel Document: Attached Your expertise would be greatly appreciated! Jay
My whole Excel world is crumbling around me - interlinked workbooks using a lot of formulas and VBA
I have a 'set' of about a dozen spreadsheets through which I drive my family history projects. I have been having problems, for quite some time, with their opening as a 'set' and now, since the software updates which came through on 13th June, many of the interlinked formulas are just failing. Firstly when they are opened up, through a .bat file, they open up with the Internet source warning, despite the fact that all the workbooks, and all the associated xlams, are on one of my own hard drives and I created them all. I have added the directories to my safe sources list but they still come up with this message. Secondly, many of the formulas / workbook openings create messages, which say that the workbook has not been updated because the other spreadsheet was not recalculated before saving - such recalculation is not necessary in many cases. How can I remove this unnecessary check? Thirdly, some of the formulas are getting 'corrupted' every time I close the file, so that I have had to keep a text copy of the formulas in the worksheet, so that I can copy and paste the uncorrupted text of the formulas back in, every time I re-open the affected spreadsheets - this is a most annoying and time wasting activity - any ideas would be welcome, please. One thought I have had is that these 'corrupting' formulas are often quite complicated, often using quite a few nested IFs and/or VLOOKUPs [the VLOOKUPs often being ones that look across to another workbook]: would it be better if I tried to turn these formulas into my own VBA functions, maybe? With hopes for some ideas, please. I wish I could send someone the whole set of stuff, so that they could look for the flaws in my Excel use, but as a disabled pensioner I cannot afford to pay anyone, so I have to rely on Internet forums to try and get some help, please. Best regards Philip Bendigo, Victoria Australia
