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

Copy For Cell Values Present And Not Formulas Present

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

Why Match Turn Out NA But Data Is Present

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

Match Not Working (establish The Values In One Sheet Are Present In Another)

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

Fill In Value If Two Cell Values Match

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

Compare Two Cells If They Match Then Fill In The Cell From Another Sheet?

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

How To Highlight Cells Present In ALL Columns

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

Copy/Fill Down Formula To Maximum Row Of Last Cell In Columns

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

Compare Cell Contents In Different Columns Then Fill Neighbouring Cells

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

Delete Columns And Rows Based On Cell Fill Color

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

Dynamically Fill Range Of Columns Based On Value Of Cell In Another Sheet

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

Find The Data In Some Rows That Match With One Cell And Automatically Fill The Data

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

Linking 2 Columns To Fill 2 Columns In Dropbox List?

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

Multiple Columns Which Need To Be Combined With Some Columns Not Having All Cells Fill

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

Match 1st And 2nd Columns In 2 Sheets And Return 3rd / 4th And 5th Column If Match

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

Conditional IF/THEN 9checks If The Value Currently Present In Cell )

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

Present List When Cell Selected

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

Find And Match To Fill Data

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

Delete Contents Of Cell If Text Is Present?

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

Delete Contents Of Cell If Text Is NOT Present

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

Checking If A Value Is Present In A Cell If So Changing To The Cell Below

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

Match Column Value And Fill Color In The Row For Matched Cells

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

Fill Multi Cells In Row If Column Match Both Worksheets

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

Find Time Difference Between Two Cells And Present The Date In Third Cell?

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

Auto Fill Week Dates To Match Weekday And Month

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

Subtracting 2 Columns Of Data From Each Other When Labels In Separate Columns Match

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

Calculating Percentage In Cell And Omitting Values When Specific Words Present

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

Using VLOOKUP To Fill Data With A Partial String Match Separated With A Dash

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

How To Match 2 Columns And Count Their Match

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

Excel 2010 :: Icon Conditional Formatting Not Working When Formula Present In Active Cell?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved