formula and functions

Hi everyone!!:) Down below I have a list and the problem is this: I want to generate items from the list when a precise value like: 875 X 1150 or 1478 X 3620 is entered in a cell . Let say, someone has entered : 875 X 1150 or 1478 X 3620 in (column A) and I want in (column B) the rounded...

What can I add to the following formula that will leave the cell blank until the formula is calculated - so this doesn't show as the result: #DIV/0! Simple formula: =(B17+C17)/E17 Formula is in cell H17 which I want to remain blank until the formula can be calculated, then the result of the...

Hi smarties I am trying to make a table that turns this: <tbody> John potato 1 Mary cranberry 5 David salsa 4 Stacy potato 6 Greg potato 2 Anna salsa 3 </tbody> Into this: <tbody> John Potato 1 Mary Cranberry 5 David Salsa 4 Stacy Potato 6...

Hello friends! Unfortunately I am not permitted to upload the sample spreadsheet so I'll describe it. I am practicing with a formula from a test table with Qtr1-Qtr4 on top and NE,SE,NW,SW on the left, Totals at the far right and bottom with sample numbers in the cells. I have saved the Names in...

<tbody> TOM CANADA PANCAKE MACK ENGLAND HOTDOG HARDY USA BURGER TOM CHINA MOMOS MICK CANADA PIZZA </tbody> Hi, I have 3 columns , in column A I have around 220 line items which are unique words, in column B there are 433 line items which are unique. All the items in one...

Here is what I'm looking for: Column A Column B Column C 120,000 50,000 X 100,000 25,000 110,000 25.000 X 330,000 100,000 Grand Total I would like a formula that searches Column C for an "X" and then...

Hello , i need put in validation data a formula or vba a code for check the next : In sheet “Codes” put the code for example in column C “asdf” and in the column J put 2. In the second sheet “Pool” put the next below: <tbody> Codes Number Asdf 100 </tbody> I need check for the same...

My workbook is broken into 3 separate sheets, #1 I am entering in a daily amount of different bundles and or products which each have their own cell. This string of data is essentially copied to sheet #2 and deleted from sheet #1 as sheet #1 's only responsibility is the daily input. Sheet 2...

Hi, I need some help please, I work with a basket of products that fall under different groupings (a,b,c) I want to execute a price increase on my turnover and of x percent but I want to make group "A" increase by a certain percentage only and then be able to calculate the increase on the rest...

Hi Everyone, I need help in excel. Please find below for example: <tbody> A B C D 1 Vikas Agarwal John Monty 2 Parul sharma Brown Peter Chris 3 4 </tbody> i want to take all words mentioned before John/Peter. so my B1 should be Vikas Agarwal and B2 should be Parul...

hi all members in the link below i put smal exempl for the resultat which i'm looking for, the idea is how to extract duplucate value in other column. by the way the column F and G has a thousands of values https://1drv.ms/x/s!As8Mdv-a95REhU6iGQZ1-oyfh_Ti excel version 2007

Hello, I'm not sure how to ask the question to my problem, hopefully, my question makes sense: I am using Excel 2016. In Worksheet A, cell A1 = $1,000, cell A2 = $1,000, cell A3 = $1,000. In Worksheet B, cell A1 needs to equal if cell B1 = X then worksheetA1 and/or C1 = X then worksheetA2...

D=July E=August F=September G=October H=November I=December I have this formula: =SUM(D9,G9,I9)/3 in cell R9 In cell T9 I need a formula which states: If R9=D9, July, , If R9=G9, October, , If R9=I9, December, , (the extra space and comma are there purposely so I do not have to use...

I have a spreadsheet that the names are formatted last,first (starting in cell A2) but I need the order changed. I know the excel formula but that requires me to enter it into an empty cell. Is it possible in VBA to have it switch the order (first last) in the same cell (A2) so it just changes...

Page 1 C372)Ag Non Real Estate C374)City. D375)#loan E375)Balance C375)Ag loan. C376)Ag line Page 2 A1)Ag Non Real Estate. B1)City. C1)Product. D1)Ag loan. E1)4. F1)$480 Ag Non Real Estate. City. Ag line. 3. $350 (same layout as first record) How do I bring back the count and dollars to page...

I am looking for some help on creating a formula that will return the first day of each week in a quarter based on the current year and eliminating holidays. Each returned value would be populated in the header of each column. Quarters are as follows: <colgroup><col><col><col></colgroup><tbody>...

Hi, I have to make some calculations using the last row of the inserted data. Need to be as formulas not macro neither VBA. Any help is more than welcome. In the next day will be more data that have to replace the ones in line 2. <tbody> total potatoes tomato apple this line should copy...

Hi, =SUMPRODUCT((Sheet1!$B:$B='Sheet2'!$A2)*(Sheet1!$I:$AL='Sheet2'!C$1)) The formula above is forcing me to select the cell then press enter on each individual cell to calculate it. I've checked the formula calculation is on Automatic and the cells are formatted to general. Can anyone advise...

Hi Folks, I have this formula that finds one column of matches but I need a second column to also be returned. I need help in fixing this formula to allow the second column of matched info to be listed in column D if possible. Thanks Formula: =IF(ISERROR(INDEX('Analysis...

I'm creating a video game that uses an 8 by 8 grid. I need half of the 64 cells to be black and half white. I'm using conditional formatting to highlight the cells white or black. I've got a randomizer to randomly make the cells either black or white. But, I can't figure out a way so that - no...