adjacent

Hey Everyone, I have a list of data but the way the data is pulled there is sometimes spaces between the numbers like seen below. Does anybody know of an automated way where I could transfer these numbers into the adjacent column with the spaces removed? Any help is greatly appreciated...

I'm trying to figure out how to conditionally format a column of cells based on the value of an adjacent column of merged cells. Each adjacent cell consists of four merged cells. So basically, if the merged cell is 0 or blank, I would like the adjacent cells to also be blank.

Is there any way to auto populate today's date in column A if the adjacent cell in Column B is populated manually from a drop down list Without using VBA??

Hello everyone, I' m new with VBA and I have a problem. Simply put, I have multiple sheets open each named after the date ("1.1." , "2.1." etc. let's say it goes for the whole year). I have an engineering simulation for a solar system. Basically I have in one column let's say column A multiple...

Hi, I have a large database resembling the image below, with instances of similar text values in one column and a corresponding numerical column next to it. I am trying to modify the numerical column such that when I edit one numerical cell, all cells in the same column with similar (not...

Hey guys, So I am running a daily fantasy regression analysis and I need some help. I have found that certain criteria is better suited for predicting some player's performances than others. So I want to run a solver that will pick which criteria to use to maximize the R squared value. I...

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Value Result $A1 $A2 $B3 $B4 $G4 SG5 $D4 $D5 </tbody> </tbody> I have the values in the "Value" Column...

I was using the following and it works great when searching one value but I want locate IMAX, FTNT, AWO and replace adjacent cell if found if not found then I want to findnext until the search is complete but I don't know the correct code to loop this any help would be appreciated...

Greetings, I have a spreadsheet where data in a cell contains carriage return at random places. I used split & char(10) to remove carriage return & bring the data as a unique text in separate cells of a row. The contents of the orignial data with carriage return are such that, my first row may...

Hello, I am building a sheet to keep track of various standards' revisions of the our industry. I would like to display the quantity of outdated standards in a welcome page but I can't get my formulas to work. I want the formula to count a cell if it matches the adjacent cell. I have tried...

Hello! If I have this list: <tbody> A1 A2 A3 A4 A5 B1 B2 B3 B4 B5 B6 B7 B8 C1 C2 </tbody> In another sheet I have a cell where I want to populate 1 of 3 options based on whether the value in an adjacent cell is a part of the range I have defined in the list...

Hi There, Is there a way to fill down multiple non-adjacent columns at the same time? I have a large worksheet and need to fill down a formula in every 5th column without altering the data in the other columns. Thanks kindly. Paul G.

I rarely need to do more than basic calculations in Excel these days, and it seems I've forgotten most of what I once learnt! This one I think should be relatively easy; Sheet1 - In column A on there are dates listed (range A1:A200) In column B we have a number corresponding to each date...

Hi All, Let me state the scenario: Cell A1 contains "-50" and cell B1 contains nothing. Cell A2 contains "-50" and cell B2 contains nothing. Cell A3 contains nothing and cell B3 contains "+51". Cell A4 contains nothing and cell B4 contains nothing. Cell A5 contains nothing and cell B5 contains...

I am trying to pick up a value using the offset formula. At present I have a formula in cell A1 as follows =INDEX(INPUT!C8:V8,1,MATCH(INPUT!C4,INPUT!C7:V7,0)) In Cell B1 I want a formula that will pick up the value to the immediate right of whatever cell is being picked up in cell A1. So...

Hello experts! I need some of your kind help -= I have 3 columns of data: Column C has a list of employee IDs, column D has a range of dates and column E has a time. I need to return the time that is in the same row as the employee ID and the date. I know it has something to do with...

I have a large document containing items that I am trying to number from 1 to x. I have manually entered 1 through 6 below as an example of what my document looks like, and I know about simple dragging of the fill handle (when all adjacent cells are uniformly non-empty), but how can I...

Hello all, I have time and speed data. Each row has a vehicle speed recorded at every second, e.g Sec Speed 1.....0 2.....2 3.....4 4.....3 5.....0 6.....0 7.....0 8.....3 9.....5 10....6 ... ... Most workbooks I'm working with have around 100,000 rows of data. I need a way to find...