Fill Cell W/ Value Present In Another Row, If Columns Match
Jun 30, 2009
I have a slight conundrum that goes as follows:
If in a given row, the cell in column A is empty, but the cells in columns B and C have values--would it be possible to automatically fill in the empty cell with the same value of another rows column A cell, if both rows share the same value (nb: not case sensitive) in the column B and C cells.
For example:
If one row, say Row 44, contained the following:
Column A Cell =
Column B Cell = sunday
Column C Cell = dog
and another row, say Row 10023, contained:
Column A Cell = Walk
Column B Cell = Sunday
Column C Cell = Dog
How would I go about automatically filling in Row 44's column A cell with the value "Walk", as both rows columns B and C cells match up.
I should mention that I am dealing with a sheet with over 30'000 rows, so it would be incredibly time consuming to find matches and input the missing value directly.
View 13 Replies
ADVERTISEMENT
Sep 11, 2009
The following code fills down column B for rows 3 to 110, regardless of the inserted "If Not IsEmply' statement. I've got formulas in Column A from row 3 to 110, but visible values in rows 3-5. I want it to fill the for the visible values only.
View 2 Replies
View Related
May 12, 2014
why match turn out NA but data is there ,I'm not very good in this or this formula don't really work,
View 5 Replies
View Related
Nov 23, 2008
per attached I'm trying to establish that values in one sheet are present in another. The MATCH function isn't returning anything.
View 5 Replies
View Related
Jan 21, 2010
The first two columns in my document coincide with their respective values. Column A (File Number) is coded for Participant Description (Column B) and the values in each row are associated with one another...
However, I have a 3rd column (Article Number) whose values mean the same as the File Number column, but the the rows don't match up.
What I need is a fourth column. In this column I'd like the value from the Participant Description column to be imputed if the Article Number and File Number column are the same.
An example from the attached spread sheet.
A2 = 7, B2 = 6, C2 = 7 - I need D2 to equal B2
That is easy enough, but this is where I get lost...
A2 = 7, B2 = 6, C3 = 7 - I need D2 to equal B2
View 6 Replies
View Related
Oct 19, 2012
I am trying to compare two cells and if they match then I want to fill in a list on sheet one from sheet two.
I have the absolute working when I compare one cell to one cell, but I can't get it to compare one cell to a range of cells (two weeks of days)
Here is the absolute one I have working:
=IF(C1='Data Sorted'!A1,'Data Sorted'!A2,"")
Here is what I tried that doesn't work:
=IF(C1='Data Sorted'!A1:N1,'Data Sorted'!A2,"")
View 6 Replies
View Related
Feb 20, 2013
highlight cells that are present in all selected columns. For example, if i had a file with 6 columns in it, I would like to highlight the cells that are present 6 times (once in each column).
View 10 Replies
View Related
May 27, 2008
In a worksheet I retrieve data from a SQL query. Now I have to add 5 different calculations per row and each calculation will be stored in a new cell (so 5 columns will be created)
I want to do this with a loop macro and calculate this till the last "filled" row. The number of rows differs every month.
What loop code should I use and can somebody give me an example of the VBA code.
Note that some formulas contains nested If-functions.
View 6 Replies
View Related
Jun 9, 2014
I have two sheets:
- sheet 1 ('current')
- sheet 2 ('31May')
The data in column C is the same, although sorted differently and can't be re-sorted to be the same. Where the data in column C is the same in both sheets, I want to fill columns A and B into sheet 1.
View 4 Replies
View Related
Jan 31, 2014
I am a locksmith and attempting to write a spreadsheet app. for my line of work. The output page will use columns A-G and rows 1-?10000? depending on the size of the system. If a 5 pin system is requested then columns A+B will be blacked out. 6 pin system A is blacked out. 7 pin system nothing blacked out. Also, if any cell matches the master key that was input, that cell is filled with red. I know, confusing.
Basically, I am trying to remove the blacked out columns automatically, and to remove the enitire row is any cell in that row is filled with red. Then to remove blank lines.
View 2 Replies
View Related
Feb 24, 2014
I wanted to enter value in sheet1 on A1. Columns in sheet2 from B1 until the value entered in sheet1.A1 should be automatically filled.
E.g.
Sheet1.A1=5, then Sheet2.B1=1, Sheet2.B2=2, Sheet2.B3=3, Sheet2.B4=4, Sheet2.B5=5.
if Sheet1.A1=3, then Sheet2.B1=1, Sheet2.B2=2, Sheet2.B3=3.
if Sheet1.A1=7, then Sheet2.B1=1, Sheet2.B2=2, Sheet2.B3=3, Sheet2.B4=4, Sheet2.B5=5, Sheet2.B5=6, Sheet2.B5=7
etc.
View 2 Replies
View Related
Aug 17, 2009
I want find the data in some rows that same with one or more cell and automatically fill the data. And for more details, I have attached the examp file (Examp.xls).Antoni
View 3 Replies
View Related
Mar 3, 2014
It's quite easy, I am trying to do a droplist (that's easy) but I want that drop list to take infos on 2 different columns and fill the 2 columns I want in the main sheet (see attachment)
On tab 'dealers' I have dealers name and account numbers. On tab 'Mileage' I have a cell call "NAME' and a cell call 'Accnt #/NB'. Here is what I want to do:
On sheet 'Mileage' I want to choose from a drop list a dealer name and I want Excel to populate the cell "Accnt#/NB" automatically by chosing the account number that is appropriate to the dealer choosen which is column 'B' in the dealers tab.
View 2 Replies
View Related
Apr 30, 2014
I have a spreadsheet with 10 columns which are for tags for products. Some columns are filled in for 10 products and some are not. For instance, product 1 has 7 tags while product 2 has only 2 tags and so on. Now what I am looking to do is combine all the tags for each product with a "," inbetween each one. The problem is if I just use a simple =A2&","&B2&","&C2 etc formula is that if there are only 2 tags then I get 8 ","s. I also tried it with an IF statement but by the time I was done nesting items I became cross eyed and said there has to be an easier way to do this.
I have create a spreadsheet with the data and the result that I typed into the "result" column.
View 3 Replies
View Related
Dec 15, 2013
[URL]
What im trying to do is match columns A & B from AUDIT Sheet to Columns A & B in MASTER sheet. If they match then pull columns C, D & E from MASTER into AUDIT.
View 9 Replies
View Related
Jan 4, 2009
I have a dropdown list in A1 of sheet1 that is populated by a dynamic named range beginning on A1 of sheet2. I also have a dynamic named range beginning on C1 of sheet2.
I want to create an IF/THEN function that checks if the value currently present in cell A1/sheet1 is also in the range at C1/sheet2. I have achieved this using lengthy OR() functions, but I want to get away from this.
View 2 Replies
View Related
May 20, 2008
In sheet1 i have a Listbox(Controlbox), which stores data of 100 names. Now in the D column i need to type the Name. So i would like to have a code which can pull the list box below the Cell I am Typing and it has to match the strings i type to list box(i.e, Pull data from the Listbox as i type the character in a cell)
So here i need 2 Modules
1- Which will pull the data from the listbox
2 - which will bring the list box below any cell which i am typing
View 3 Replies
View Related
Feb 23, 2009
I humbly seek assistance and help to fine tune my "find and match" function that works between 2 files. I am using the following:-
=INDEX('[Jan 2009 Sales & Gross Profit Record.xls]PG'!$D$3:$D$12,MATCH(C4,'[Jan 2009 Sales & Gross Profit Record.xls]PG'!$F$3:$F$9,0))
My problem is I am only able to do it in D9 where customer and amount are matched correctly. But when customer appears more than one then it doesnt match corectly.
View 13 Replies
View Related
Feb 13, 2014
Need to search a sheet and find cells that contain the text "Requirement". If found then i want that cell to become blank.
example
so in sheet1,
i have a number of columns and a number of rows
in cell A3 the value is - " there are requirements"
in cell F23, the value is -"the Requirement is"
since both cells have the word requirement, I want these cells to become blank.
View 1 Replies
View Related
Feb 19, 2014
Need to search a sheet and find cells that contain the text "."
Want all cells that don't contain a "." (dot) to be erased from the sheet
Example : so in sheet1,
I have a number of columns and a number of rows
in cell A3 the value is - " there are requirements."
in cell F23, the value is -"the Requirement is."
since both cells have "." ( dot) , I want these cells to remain in the sheet, but the rest of the cells should become blank.
View 3 Replies
View Related
Feb 28, 2007
Problem Designing "new customer" form, a textbox(forename) in the
form has the Control source of "B3" (an empty space in my Customer
database). When the form is run and the forname is typed in the box, it
fair enough appears in the Database sheet (in B3).
However, then when opening the form again and typing over the forename
just inserted it will ofcourse overwrite it (B3 is replaced). Any ideas how i can input
code into the sub linked to the textbox so that it checks the control
source and moves down if the source is empty(code checks B3 for text, moves to B4) then the next one (B4 is checked, moved to B5).
Dim topCel As Range, bottomCel As Range, _
sourceRange As Range, targetRange As Range
Set topCel = Range("B2")
Set bottomCel = Range("B65536").End(xlUp)
If topCel.Row > bottomCel.Row Then End
Set sourceRange = Range(topCel, bottomCel)
Set targetRange = Range("B3")
View 9 Replies
View Related
Jul 26, 2014
I've an excel table containing the list of expenditures of employee. I've to sort the table and use different colors for different employee rows.
How can I do this task using formula? Is this possible?
Please see the attached excel sheet for the sample table and desired output.
View 1 Replies
View Related
Nov 6, 2009
I have an exported Excel worksheet1 from the parts database get every Friday. We get RFQ of parts list each week from multi customers about 3000+ parts as they send in MSword, MSoutlook or MSexcel to me I make into Excel worksheet2. I do not like to type in every part into the parts software I have my words for that software Cough Cough. The exported excel speadsheet tells the part numbers, Location, Qty, Price, ETC I would like to take the Excel RFQ list and have it populated from the other speadsheet
SAMPLE
A1 PART number that on both spreadsheet
A2 QTY on both there request and our stock
A3 Price
A4 Location
So want a compare worksheet1 with worksheet2
A1 = A* the populate A2-A4 with worksheet1 data
View 5 Replies
View Related
Jan 6, 2014
i am trying to find the time difference between two cells and present the date in a third cell. The data in the cells are in a non standard date/time and i need to create a special format i think. The cells look like this.
fldcollected fldaccepted Type Time between being received by database and eccepted
2013-11-06 15:59:29.1002013-11-07 08:41:12.000PSTN
View 3 Replies
View Related
Nov 18, 2013
How do I auto fill a series of 2014 dates in the row below the weekdays? I have a row C5 that has a series of auto fill weekdays successfully for 2014. I can't seem to auto fill the weekdates in the row below. I have to make manual adjustments for each Monday, and for the correct month ends, etc.
View 8 Replies
View Related
Feb 20, 2009
I have four columns of data, as follows:
label 1, value 1, label 2, value 2
I need to create a formula in the fith column that for each line will tell excel to:
look for entry in 'label 1' in 'label 2' if there is a match, then subtract value 1 from value 2, display result.
I have tried doing this with SUMIF but am getting nowhere fast....
View 7 Replies
View Related
Apr 5, 2014
I have a daily report that gives a percentage based on what is typed into the "Supplier" and "Total Sales" columns but I'm having trouble writing the following formulas since my excel knowledge is relatively low.
1. Where a cell in the "Supplier" column says anything but "Den", "Burrowed" or "Studio Nyx" I need the "60%" and "40%" columns filled with the relevant formula (=B11*60% for example) and the "100%" column blank.
2. Additionally, if the cell contains "Den", "Burrowed" or "Studio Nyx" I need the "100%" column filled and the "60%" and "40%" blank.
View 6 Replies
View Related
Aug 18, 2014
I have a list of items in Column A and size info on Column B i want to being in the info to another sheet with a vlookup but the problem is that I have a lot of items with different colors so after the item no. it has a dash and a letter or two for the color so i want to bring into my new sheet all info.
I have in my old sheet for all items regardless of color so for instance in my old sheet i will BR1000-EM and then in my new sheet i will have BR1000-R and BR1000-SA and BR1000-YC how do i make a vlookup it should only lookup the values in both sheets only till the dash (i cant use a certain no. like left,6 because the item no can have more then 6 but it always has a dash when it has a color code) also not all items have dashes so the dash is not always there but when its there i would like that the lookup should stop by the dash.
View 6 Replies
View Related
Jan 28, 2008
HOw can I match combination columns of A-F (row1) to combination H-M (rows1 to end) and show how
many are number matched in column N..
ex..
Rows
A
B
C
D
E
F
G
H
I
J
K
L
M
N
1
2
3
16
17
11
9
11
17
18
View 9 Replies
View Related
Mar 20, 2014
I am trying to apply icon conditional formatting in a cell. The cell contains the following formula: =VLOOKUP(D20,'owssvr(1)'!O:W,9,FALSE The formula results in a "2", "1", "0" or "-1" in the cell. The icon conditional formatting is not working at all (no icon appears). I have the conditional formatting setup as numbers Green 2, Yellow 1,0 etc based on value. If I delete the formula and just type in any of those numbers directly, it works. I have changed my cells to "number" and it still does not work.
View 3 Replies
View Related