fourth

My friend have today() in one cell. second column put birthday mm/dd/yy. Third column have future how year. fourth column is how old he will be in future age here link to get the file https://1drv.ms/x/s!AnJwxxiz0Ezpg8h3vO4Rqi1ekoGgmA?e=8ydGh1 Thanks You Thomas

I have Excel 16 on MacBook I need to be able to search 2 columns and if there is a match to move the corresponding value in a third column to a fourth column Example If column A6 has a value equal to column B8 then I want to move the value in column C8 to column D8

Morning! FOQD = a range of dates. FOURTH_QUARTER = a range of number for the fourth quarter. The formula is displaying the first date in the range however the data for this date is zero. Being that the fourth quarter doesn't have any data yet. (works right with data) How can I make the formula...

I'm trying to make a spreadsheet such that when the day changes (Cell B2), an operator changes another cell and a third cell is cleared. On top of that, whenever a value is entered into a fourth cell, it is added to a fifth cell and the fourth cell clears. My code is below. When I enter a...

I have a workbook for clients, one worksheer per. Is it possible to loop thru those workbooks an create a list of how many items are in each worksheet tabulated by worksheet name? So if I have three workshets [a,b,c] I would get a fourth worksheet with two columns r1c1=a, r2c1=b, r3c1=c and...

I don't know if it's possible, but I would like to do a "Variable" VLOOKUP. Let me put it in an example. Imagine I have a workbook with sheets named "A", "B" and "C", and then a fourth sheet with a dropdown selectable, with values A, B and C. In that fourth sheet there's also a VLOOKUP function...

I have a spreadsheet where i have four columns (B, D, E &F) which hold info which i need to concatenate to create a unique reference number. The issue i have is that the first column contains text, the second & third contain two digits and the fourth contains three. The second, third & fourth...

Hello to all! I have a list of values in one cell. The case : 5.1-5.28, 5.1-5.28, 9.5-10, 9.5-10 I want to extract the first value in one cell, second in another, third... you got it. But sometimes I can have let's say : 5.1, 5.1-5.28,10, 9.5-10 In this case, the first and third value are...

hi folks, I get a daily file that has Alpha/Numeric content. to separate various entries, the originators add Char(10), at times two of them. looking for a formula that will find the second, fourth, sixth, eights, etc. Char(10) and replace it with "". it should not return an error is there...

I have for columns and am trying to create a formula that will place "X" in the first column if: 2nd column is greater than 11 and the third column is greater than 85(regardless of the value in the fourth column), or the 2nd column is greater than 11 and the forth column is less than 1.5...

I have four footnotes to a report that each include a calculation and text, I thought I found a solution until I needed to enter in my fourth footnote. Using the Char() formula, I have thus far been able to achieve having a superscript number, so far 1,2, and 3, and then text and formula as a...

Hello all in Mr Excel land This maybe a stupid question for people in the know but I need help on this please The formula below is what I need [With Range("B4:B"& LastRow) .FormulaR1C1 = "=SUMIF(Suppliers!C1,RC1,Suppliers!C2)" .Value = .Value End With] But I want to...

Hi there. Is there a way so if I put 'Mon' in one cell the next 6 cells across automatically enter Tue, Wed, etc? So if I start with 'Fri' the next cell till start at Sat and so fourth. Cheers, E

Hello everyone, (First time poster here) I am an educator and I would like to create a VBA script to help me with a specific type of grading I would like to perform in Excel. I would like to be able to click a cell that changes the value of that cell. For example: Assume cell C2 through C70...