# Tagged Questions

**0**

votes

**1**answer

35 views

### Excel SUM function for whole column?

How can I sum the whole column without freeze head?
I have a situation: I need to SUM each column, but the total rows in each column will keep changing. users are keep adding data in each columns, ...

**1**

vote

**1**answer

15 views

### Microsoft Excel lookup match without sorting data

Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...

**0**

votes

**1**answer

33 views

### Defined Name to give text or date value instead of numeric value

I had been trying out Define Name in Excel. I defined a name for a cell in which I would put a text or date value or I may leave it blank.
But when I use this defined name in another cell, the second ...

**2**

votes

**1**answer

35 views

### Excel - sum values based on a column that match another column in another table

I've been working my head around this, but haven't figured it out yet, and I'm sure it's dead simple.
Suppose the following example:
There are two tables, one containing animals, and the other one ...

**1**

vote

**2**answers

34 views

### MS Excel Column content replication across two sheets

Microsoft Excel functional Question
How do I replicate (copy a column contents of Values to another sheet column) of a whole column (with data content) from a primary sheet to an secondary sheet in ...

**0**

votes

**3**answers

39 views

### In Excel replacing a column with another column

I have a list of Variables in Column A > list of items
another list of variables in Column B > with corresponding Item Codes for >> column A
And in Column C > I have list of item codes randomly ...

**0**

votes

**1**answer

16 views

### How to match Reg No. in one workbook to another

I want to find out a formula to match Reg No. for two workbooks.
First work book is a master book I update everyday almost, next workbook I have employees name and ID numbers only, nos are in ...

**0**

votes

**0**answers

25 views

### “Filter by Selected Cell's Color” is so slow

I have a row includes like 60-70 thousand lines. 30.000 of them colored. And I'm trying to filter them by "Filter by Selected Cell's Color" but it's so slow. It take forever to filter just 70.000 ...

**0**

votes

**1**answer

49 views

### Can Excel's Find formula have multiple find_text criteria?

I have a list of names on a NAMES tab range A1:A100.
On another tab 'Data Export', in column A I have an export of thousands of comments where one of those names from the NAME tab can be found within ...

**2**

votes

**1**answer

43 views

### Horizontal Index Match Excel 2007

i have a list of customers rows 1-500 column B, with their purchases showing in columns u-AB
and based on the maximum purchases done under a specific column (u-ab), the customer will be tagged as ...

**-1**

votes

**1**answer

30 views

### Conditional Formatting from Helloh, for a Noob

I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...

**0**

votes

**1**answer

79 views

### Excel - Script that search a sheet for a cell containing specific text, and replace the text with a specific value

I want to split a cell with data into other cells based on the data in the original cell. The data from the original cell looks like this (all content in a single cell):
...

**0**

votes

**2**answers

38 views

### Indirect turns up with #ref error

I want to use INDIRECT in a formula like =INDIRECT(CONCATENATE(A1,"+",A2),0);
where A1 = 7 and A2 = 8.
It comes out with #REF error all the time, but if I use the INDIRECT formula like this: ...

**1**

vote

**1**answer

64 views

### IF statement with multiple answers

I want to make a table and c4 will be radius required and the minimum weight for that radius requirement will be in D4
The chart is;
radius quantity
0,040 - 0,06 : 33
0,061 - 0,10 : ...

**0**

votes

**0**answers

43 views

### Getting data from closed files with concatenate formula

Challenge is this:
Each day program is creating an excel file for me with some data for the current day.
Like what is the price for products, how many people are available today and things like this.
...

**0**

votes

**1**answer

34 views

### Count from a cell with value to the end of row and dividing total by number of number of months regardless of blank

How do I write a formula that will auto start sum from the first cell with value though to the end which including blanks, and then divide the total by number of cells from the one with value through ...

**0**

votes

**2**answers

88 views

### Compare two columns in two sheets

I have another question, even though the last one i asked is still pending. I have a large data of over 100,000 records. I am using the code below to loop through the data so that any duplicate ...

**1**

vote

**1**answer

28 views

### Return Earliest Date from a range

I have an excel spreadsheet where I want to pull the earliest date in the column based on the criteria in a different column (for a given tech) into a different sheet. Rows on sheet1 contain store ...

**1**

vote

**1**answer

89 views

### Conditional Formatting in excel based on another column

I have an excel worksheet and two columns. I highlight the first column if the value of the cells are less than 0.
Now how can I highlight the second column cells based on the first columns that are ...

**1**

vote

**1**answer

85 views

### Need a Excel script to identify email addresses that contain a different variation of the first name of the contact

I have an Excel spreadsheet with 50k+ rows of data, where we are trying to identify within the rows of data where the email address has no match of the first name, etc.
We are basically trying to ...

**0**

votes

**0**answers

35 views

### Displaying some cells data depending on selected text from other sheet

I have an excel sheet which looks similar to below and with some more columns.
Area Branch Empolyees Products Shelfs
Area1 Area1 Branch1 10 Product 1 10
Area1 Area1 ...

**0**

votes

**3**answers

61 views

### Need help on using a few excel formulas together

I have some particular data in sheet1 and some other data in sheet2.
I need to compare a specific value(Var1) from sheet1 and return a specific value from the sheet2, and return an output for the ...

**0**

votes

**2**answers

36 views

### Excel 2007 - refering value from other worksheet in another function in excel

I have two worksheets. I have data in Sheet2 in column A for which i want to use average function. In sheet1 i have values in only two cells. B1 cell has value 5 and B2 cell has value 15. Using these ...

**0**

votes

**2**answers

33 views

### “#REF!” appears in cell after referred-to cells are pasted in

On Office 2007's Excel on Win7, I have a file with a formula like AVERAGE(A29:A33) in cell A34. I then copy four vertically-adjacent number-containing cells and paste them into cells A29:A33. At ...

**0**

votes

**1**answer

14 views

### How to delete and retain a particular value in a cell based on the value of a certain cell?

How to make a vb code to delete the contents of Column B when i entered a specific value in column A?
Example: If cell A1=apple, cell B1 should delete whatever value it have. But if cell A1=grape, ...

**-1**

votes

**2**answers

153 views

### How Do You Stop Auto Formatting to a Cell I'm Using as a Barcode Number [duplicate]

I am having a little bit of a problem with Excel. I am typing into a cell a barcode number for my products but every time I leave the cell it automatically formats the cell as below.
Number I want to ...

**1**

vote

**2**answers

51 views

### Excel: Check for specific value in a matching row

I want to check which products (listed in rows) are produced by which company (listed in column headings) in order to fill a table like this
Company A Company B Company C
Product 1
...

**0**

votes

**1**answer

79 views

### Calculation of hour in Excel using [h]:mm formula

START END TOTAL TOTAL
21:00 3:15 6:15 6:15
23:25 1:11 1:46 1:46
20:25 5:20 8:55 8:55 ...

**0**

votes

**1**answer

28 views

### How do I lookup using 2 values, Verticle and Horizonal? (Apple Numbers)

I have a sheet that has an individuals info, one table as their Age (TABLE 1). Another Table has a score in cell (TABLE 2). I want to lookup the VALUE that corresponds with their age and score in ...

**0**

votes

**2**answers

34 views

### Force a one-dimensional array into a constant in Excel

I have a condition in an Excel IF-statement as follows:
INDIRECT(ADDRESS(ROW(ME3),MATCH("PremiumWaiver",$1:$1,0)))=1
where
INDIRECT(ADDRESS(ROW(ME3),MATCH("PremiumWaiver",$1:$1,0)))
eveluates to ...

**0**

votes

**2**answers

195 views

### Comparing two columns in different Excel spreadsheets

I have two Excel spreadsheets. In the first spreadsheet I have two columns. Column A has 240 Accounts entries and Column B has Values for each account entry. Once again Spreadsheet 2 has its data in ...

**3**

votes

**2**answers

923 views

### Excel-Count number of visible cells containing certain string

I have a sheet in which I first apply a filter to a certain column to show "Unique records only". Now I have a column which contains, for e.g., values like:
Applepie
Applesauce
Crabapple
Banana
Mango
...

**1**

vote

**1**answer

34 views

### Extending formula down the column without symmetry

Suppose this is the formula for my I2 cell =IF(C2<>C1, N2, K1).
If I extend this formula down the I column in excel, the default behaviour is
I3= IF(C3<>C2,N3,K2)
I4= ...

**2**

votes

**2**answers

101 views

### How to identify if a cell contains any of the values in a column

My question is the opposite (inverse?) of How to identify cells in Column A that contain any of the values in Column B. Specifically:
I have a list of 19,000 first names and 10,000 passwords. I'm ...

**1**

vote

**0**answers

38 views

### Microsoft Excel hyperlink function to a specific location in a Word doc

I have a long column of numbers in Excel that I have mail merged to a Word doc. I would like to write a function in Excel that will hyperlink each cell from this column to its corresponding mail ...

**2**

votes

**1**answer

32 views

### Vlookup not registering range changes in calculation

Typing the first vlookup yields the correct result. When I pull down the cell reference to use the same vlookup on other cells, the vlookup recognizes that the formula has changed, but still delivers ...

**0**

votes

**1**answer

191 views

### Excel 2007 adding a percentage increase

Value = 20 is a constant number
Percentage increase to "Value" in levels of 2%, 4%, 5% up to 20%
I would like to enter in a cell the LEVEL of the object and it return the VALUE + the percentage ...

**0**

votes

**0**answers

56 views

### Indirect lookup across spreadsheets

I have a spreadsheet that has information about all products for every week of the year.
Currently I have a second spreadsheet that is setup to look at the first one for each field (currently has 52 ...

**2**

votes

**1**answer

51 views

### Excel lookup / value formula

Ok hard to describe this one.
I want to be able to create a formula where part of the formula is populated by info in another field.
e.g.
Sheet 1
A1 = TXT - A2
A2 = number - 1599
Sheet 2
A1 = ...

**0**

votes

**2**answers

43 views

### having cell show a paticular number if the answer in the formula in the cell is a certain number

so I don't know if it's possible but I want to have a cell show a particular percentage in the formula I put in the cell comes up with a particular answer. for example, if I put in the formula =6/3 ...

**1**

vote

**0**answers

30 views

### How can I move columns based on the column header title to another workbook?

I have to average grades based on each objective for a new report card we have to complete this year. Column one has students names, each additional column will have the objective associated with the ...

**1**

vote

**2**answers

41 views

### Excel Conditional Summing

I want to create a formula so that I can keep track of how many feet get out of a drill bit. The data will be arranged in this way:
I want to show results of the total footage drilled by:
Any ...

**0**

votes

**2**answers

485 views

### Conditional formatting of a cell based on value in 4 adjacent cells

I'm trying to get a cell C3 to highlight using conditional formatting, but based on a value in 4 other cells.
If 4 continuously adjacent cells (e.g. AS3, AT3, AU3, AV3) contain the X value only then ...

**3**

votes

**1**answer

75 views

### Flatten Excel Formula (2007)

Say cell A1 has the formula A2 + A3
and B1 has the formula B2 + B2
and C1 has the formula A1 + B1
I need an easy and quick way to create the formula for C1 in the flattened state..
i.e.
(A2 + A3) ...

**1**

vote

**1**answer

65 views

### If A1>1, I would like the next 3 cells to be red, i.e.a2,a3,a4 red. But if A2>1 I also want the next three cells red

What I would like is: if ANY cell has a number greater than 1 - then the next 3 cells TO THE RIGHT trun red
Is there a way of doing this, without me having to type the formula in to every single ...

**1**

vote

**3**answers

11k views

### How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?

I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...

**0**

votes

**0**answers

51 views

### Comparing two lists of strings based on logical operatiors

I'm trying to find and merge several groups of people based on the following boolean algebra:
Let
'*'=AND and '+'=OR
group1=A*NOT(B)+C*NOT(D)
group2=NOT(A)*B*NOT(C)*D
...

**0**

votes

**2**answers

141 views

### Multiple conditions in if statement on non-contiguous cells in Excel

I would like to perform an if statement with conditions on the values of multiple non-contiguous cells, something like
...

**0**

votes

**0**answers

25 views

### How to use the Integer i.e. currentregion's row from the macro in a cell's formula

How do I use the row from the current cell, in another Cell's Formula on another sheet?
I created this Macro, but don't know how to use the Integer from the macro in a cell's formula.
In a macro I ...

**1**

vote

**2**answers

239 views

### Excel formula/VBA to detect a property of a group of rows

I have a large dataset in an Excel sheet where:
column A: quote number
column B: opportunity number
column C: sales order number.
One quote number will have multiple opportunity numbers. A sales ...