adjacent

I have some data subtotaled in column A. For each row that contains "Total" in column A I want to fill the adjacent cell in column B with the color Green. I know I can accomplish this using Conditional Formatting and a formula but I'm not sure how to write the formula. Could someone please...

Hi, i have this formula: {=(INDEX($A$2:$F$30000,MATCH(1,($A$2:$A$30000=D2)*($B$2:$B$30000=B2),0),3))} which outputs the value in the third column of range when the criteria matches. However if the criteria has multiple matches i dont know how to output all these, ideally output in adjacent...

How can I have Excel return a list of job assignments based on a particular location? Employees assigned to a particular airport in Texas have to do research in all the adjacent counties to that airport (there are over 250 counties in Texas). For example lets say Jack is assigned to do work...

Hello, I'm new to VBA and can't find a workable solution to my issue. I'm trying to insert my custom function adjacent (0,1) to each non-black cell on a worksheet. So if I have a string in cell D3, it will insert MyFunction() into cell E3. And loop through to do this for every non-blank cell...

Hi I have basic knowledge, using Excel 2010. I want to match/look up a cell value on one sheet with a unique identifier data on second sheet, and then populate on the first sheet 5 adjacent cells which are immediately to the right of the unique identifier on the second sheet. I have a lot rows...

Hi I am wanting to be able to find a max value in my first column (J and M) and from that index, copy the remaining row values in both that column and a non adjacent column, then paste these in the same sheet to 2 blank columns (say R and S) . Any ideas welcomed Many thanks Steve

I have a date column formatted in mm/dd/yyyy I have a chart that I want to automatically update as I enter data into the spreadsheet. Here's what I'm looking for help on: <tbody> Month <tbody> Jobs </tbody> Income August count if column A begins with 8 <tbody> SUM column J if...

Hello Folks,I have a very complex requirement. I need a macro to multiply based on some conditions. I have a two column one is filled with "Y" and "N" letters another one is filled with numbers. My requirement is to identify all the "Y" succeeded by "N" and multiply the value of adjacent cell to...

Hi ....New to VBA’s and I assume that what is needed to ClearCell content. I have data being added to cell ranges K16:K34. Based on theinput entered into those cells (selection is based of a Data Validation list)the information in the adjacent cells L16:L34, M16:M34, N16:N34 can then beselected...

Struggling with this one a bit. I am trying to count the total blank instances in column H when there is an adjacent value in the 5 to 10 range in column D. Any help would be greatly appreciated. Thanks

Hopefully I can explain this correctly. A2:A15 - Players last name B1:B15 - Dates of games The number of hits are entered for each player, on the date played. (actually are populated from a different page/tab in workbook) I am HOPING to change color of the TWO or more cells when the...

Guys, Got 2 columns to compare using conditional formatting to highlight if cell value is greater than adjacent cell value, but only cells containing numbers need to highlighted. Thanks.

Hello, Starting in cell I12, I have dates listed. In cells J12:AO12 i have data that pulls in based on formulas. I would like a macro that will find today's date in column I, starting in cell I12, and will copy and paste as values the data in the adjacent cells in columns I:AO, starting with...

Hello, I am trying to use data validation to check the adjacent cell for blank and the current cell must contain only the letter "x". No quotes. I have tried many variations after searching and when I use this in another cell as a true false for testing purposes is comes back as true when D15...

Hi All I am making a lookup userform for Regional Ecosystem IDs. The host spreadsheet consists of 8 columns. The first column values will be the lookup value in a combobox on the userform. I am looking for code that will fill the other 7 textboxes with the data from the adjacent columns. I am...

Is there are excel software that will read in a pdf file (could be up to say 20 pages) and then report and count the number of occurences of adjacent nouns. For example, ... dresser love... (That was of course a stupid example). However, ... dresser-love.... is not an example. Thanks...

I have searched the forum and the internet, but all I have found is conditional formatting which does not appear to do what I want. I have a column into which either a "Y" or "N" will be placed and if "Y" I would like a highlight of the adjacent cell as a reminder for me to do a follow up...

Hi,Thank you for helping me in the past. I have a formula in Cel# J2 entered as ARRAY, (which I adapted from MREXCEL replies to others): =IFERROR(INDEX('[Inx.xls]All Inxs'!$L$2:$L$9839,SMALL(IF('[Inx.xls]All Inxs'!$B$2:$B$9839=$A2,ROW('[Inx.xls]All Inxs'!$I$2:$I$9839)-ROW('[Inx.xls]All...

Hi, Can someone in the Forum help with a cell formula that will count the occurrences of when the word "Yes" appears in adjacent cells in columns H and I? Thanks, Art

Hi - So I am currently trying to work on some code that will help with the following: In Column G, I have a bunch of different data points, however some of the cells are blank. If a cell is blank I want it to look at the cell in the adjacent column (Column F) and copy the data from that cell...