Questions about using in-cell functions/formulas in spreadsheet software.

learn more… | top users | synonyms (5)

0
votes
1answer
105 views

How to require a cell input if another cell has a value

I'm trying to edit the VBA for one of my workbooks so that If there is a value in column A, then a value for column C is required or else the file won't save, but i'm having some trouble with this. I ...
0
votes
1answer
38 views

Excel: filter consistent information from constantly changing cell

I am setting up an Excel spreadsheet and I am needing to extract a dollar amount out of specific cells. The problem is that there will always be a dollar amount in the cell but the information on ...
0
votes
1answer
272 views

VBA Solution to VLOOKUP with Hyperlinks

I am looking for some help with a VBA solution for preserving hyperlinks when using VLOOKUP on Excel (2010). I have a load of data on Sheet 1 for internal use only, and a cut-down version of this ...
0
votes
1answer
1k views

Excel Return Max Text Value Using VLOOKUP

I need to come up with a formula in excel that will identify the max and min software offered on a computer and input it into a new table. So for instance, in one large table I have column names ...
0
votes
1answer
38 views

Define names in workbook scope

I use MS Excel 2010. In this app, I know that using Formulas > Define names > define name it is possible to name a cell (or range). At that dialog box there is a scope rectangle which if I choose the ...
0
votes
2answers
180 views

Is there one simple formula for Excel that can identify a string contain non-ASCII Characters?

I know that using the clean formula, I can clean up some of the non-ASCII characters (such as additional non-printable ASCII control characters #0 through to #31, #129, #141, #143, #144, and #157 ...
0
votes
1answer
77 views

Search Excel price grid with variable values

WIDTH DROP 1150 1550 1850 2160 2360 2750 3000 3480 3980 4450 1200 338 348 378 413 431 450 467 513 ...
0
votes
2answers
68 views
0
votes
1answer
82 views

How to lock a cell with formula in excel after the referred cell is filled?

I'm using "CONCATENATE" formula in excel and I would like to lock (or turn the formula into value in) the cell which contains the formula after the last referred cell is filled. Some of the referred ...
0
votes
2answers
354 views

Nneed to calculate average of NON sequential multiple cells & I want to exclude values = 0 or Empty Cell with AVERAGEIF

Nneed to calculate average of NON sequential multiple cells and I want to exclude values = 0 or Empty Cell with AVERAGEIFS. There is a mistake in my formula but I can't find a way to have it since ...
0
votes
2answers
3k views

Excel compare two columns and list a third column

I have an Excel sheet which has 3 Columns: A B C D 1 A 1 2 B 3 3 C 4 6 5 D 7 E I want to check column C for values present in column A and list corresponding values of ...
0
votes
2answers
615 views

Excel Convert XML cell to columns

I have an excel spreadsheet with XML in a single column. I know that you can import XML data into Excel; but only imports the entire file. However, I need to do this on a cell by cell basis. With ...
0
votes
2answers
42 views

Excel: Applying Condittional formatting to every other row

I would like to apply a specific conditional format to every second row in my spreadsheet. In my specific case I have regression results, where the first row indicates the beta coefficient and the ...
0
votes
1answer
162 views

=VLOOKUP() function performed on dollar value displays value without “$”

I'm not entirely sure how to present pleasant-looking spreadsheet representations on SE, so I would appreciate any advice on that issue given on the side. I want the B2 cell to display the salary ...
0
votes
3answers
322 views

In Excel need to copy a range of cells based on single criteria

I am trying to copy/insert a range of cells based on a single criteria. I have tried using the IF function as follows =IF(B6="RHH1",Sheet2!A4:J15,Sheet2!A18) The FALSE statement works and the ...
0
votes
2answers
129 views

Excel if/then formula

I am wondering if there is an if/then formula for the following situation. I am trying to populate a monthly calendar. I want the calendar to show the value in A1 if the value in B1:B100 is equal to a ...
0
votes
2answers
43 views

Two columns (pounds, kilos) convert and fill opposite column depending on which data is entered.

I'm trying to keep two columns of data. One in Pounds and one in Kilos. (1 kilo = 2.204 lbs) The problem is that when I add a row, it might be in kilos, it might be in pounds. Is there a formula I ...
0
votes
1answer
197 views

Compare two spreadsheets in a workbook, find the differences and record the differences on the first spreadsheet

I need a way to compare two spreadsheets in a workbook, find the differences, then write those differences on the spreadsheet in sequential order in the same column below the existing numbers. Sheet1 ...
0
votes
1answer
1k views

Nesting multiple IFERRORS with Index and Match

I feel like a dummy. I basically need a column that says - If column a2=0 then index and match column C, if that returns an error index and match column e, else index and match column a Current ...
0
votes
2answers
23 views

Referencing text from one cell into an equation in Excel

I have text in a cell (A1) that is also the name of a worksheet within my workbook. How do I go about referencing a specific cell on that sheet? I want it to look like the formula below without having ...
0
votes
1answer
108 views

Excel count all rows that contain certain values for certain fields

I have a sheet with a couple hundred rows. Each row has an 'owner' and a pass/fail field. I am making a second sheet that has statistics for the users. So for each user it will count the number of ...
0
votes
2answers
58 views

How to put conditional formatting in a cell from another excel worksheet [closed]

It's hard to describe what I want, I'm not really familiar with Excel condition terms but it is basically just like this: Worksheet= Dr. castro patient consultations A B C D E ...
0
votes
1answer
214 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 ...
0
votes
1answer
70 views

Apply a function/formula to a range in excel

I have many operations to perform on a set of data in excel. The data is in columns, and the functions are a lot of variations on things like =(A1*C1/B1)+(A2*C2/B2)+... Right now they are spelled ...
0
votes
1answer
214 views

Excel - find and remove text, surrounded by varying characters

I've got an Excel file with ~5,500 rows of inventory items. One cell in each row is a description field and contains HTML. Some (but not all) of these cells contain a link formatted something like ...
0
votes
1answer
84 views

How to have excel paste a value in a specific cell according to another data table

I'm working with excel 2010, I have an excel sheet with two tables. The primary table contains a calender and each calender day has a specific numeric value in the cell below the date. The numeric ...
0
votes
2answers
591 views

Excel 2010 formula, How do I write this formula? (VBA)

I need a bit of help from the more experienced Excel VBA users. Basically I have 2 groups of 3 cells (6 cells total) If one group of 3 cells is filled in it needs to accept it and not return a ...
0
votes
1answer
508 views

Advanced filtering leaving on unique values and removing duplicates

On the spreadsheet there are two subsets of data that are separated by color based on where I pulled the information from. Within these subsets are duplicate entries. I do not want to simply remove ...
0
votes
3answers
7k views

Formula =IF(VLOOKUP(…)=Cell;…) does not work [closed]

According to this and my own testing, using VLOOKUP can be compared to a specific value inside of IF. E. g.: = IF(VLOOKUP(...) = 20, [then value], [else value]) works. But if I compare the result ...
0
votes
1answer
35 views

Access table data by row index

I have a Table in Excel that is laid out as follows. What I require is a way of accessing a table row by index for a calculation. To be precise, I have been asked to work out an overall coefficient ...
0
votes
1answer
309 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
2answers
1k 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 ...
0
votes
1answer
549 views

Formula to display text from multiple cells from one sheet in another

I have a list of sales reps and the names of the customers they've sold product to, on one sheet. I have tried VLOOKUP, but it will only return one set of text from the cells. I would like to know, ...
0
votes
1answer
277 views

Automatically format currency based on adjacent column - Excel

Using Excel and need a little help with a simple formula. I know conditional formatting should do the trick here, however, I need help creating the exact formula for my need. In column A I write the ...
0
votes
2answers
194 views

CountIf()-data from different workbooks

I am trying to take data from two separate workbooks laid out like so: picker | lines --------+------ zf | 4 ag | 22 jw | 8 zf | 7 cr | 39 ag | 10 ag ...
0
votes
2answers
79 views

want to extract email address from a string of characters — pretty close [duplicate]

I am close to the end, I just need to add something in to remove the open and close parenthesis and then add a semicolon. I got this far by googling; I just need one more piece to the puzzle. :) ...
0
votes
1answer
267 views

Insert columns, within a range, based on cell reference

So am trying to tell VBA to insert a certain number of columns between two other columsn based on a cell reference. I've managed to get excel to insert columns within my range: Sub INSERT() ...
0
votes
1answer
107 views

How can I do this in spreadsheets?

Let's say you have a table like this: | A | B | C | ------------------------------------- 1| sex | age | answer q1 | ------------------------------------- 2| ...
0
votes
1answer
84 views

Subtracting hours from time

I am trying to subtract hours from a time, but it's giving me strange results A1 = 06:00:00 (manual entry, hours to deduct) B1 = 00:30:00 (=C1-A1, start time) C1 = 06:30:00 (manual entry, end time) ...
0
votes
1answer
46 views

multiple IF Calculation excel

I currently have this formula in Excel: =IF(G1+I1>E77,H1) Sometimes I want it to be like this: =IF(C1+E1>G1,D1) I need both these formulas in the same cell but there will only ever be a ...
0
votes
2answers
57 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
2answers
12k 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 ...
0
votes
1answer
3k views

Check if a Row Range Contains another Row Range values in Excel

I have an Excel file that contains two different columns having Customer Numbers (let's say CustomerA and CustomerB columns). What I would like to do to check which of the CustomerA values match the ...
0
votes
2answers
35 views

EXCEL: IF function only working if Value is TRUE and remitting a #NA if the Value is FALSE: Apple Mac Air - Microsoft Office 2011

Can anyone help me with the following formula? Basically it works when the condition is TRUE but gives me an error when the condition is FALSE. I would like the cell to remit the value "0" if the ...
0
votes
1answer
130 views

How to get list of cells that match criteria in Excel 2013

I have three columns in an Excel 2013 spreadsheet. One is an ID, one is a reference column, and one is a referenced by column. Some rows reference other rows, and some rows are referenced by other ...
0
votes
1answer
497 views

Excel formulas for budgeting sheet (or VBA code)

I'm (an amateur) and I'm creating a sheet to help me with Budgeting. I've got bills that I can enter, but that come at a variety of different intervals. I'd love it if I could enter the total from ...
0
votes
1answer
212 views

How to fill sequence in Excel from ranges given in another sheets?

I have an Excel sheet where two columns (say J and K) among data in sheet1 are as follows: J ------------ K 1 ----------- 25 26 --------- 50 101 ------ 150 Which are some ranges. ...
0
votes
1answer
160 views

Excel 2010 - Show cell contents - wrong number appearance

I was trying to create a simple function in Excel VBA editor. When I click on a cell within the certain range, I want to copy its value into another cell I have set. Private Sub ...
0
votes
1answer
40 views

how to sum the amount of cells with the same number in a column - Microsoft Excel 2010

My english isn't that good, I hope you understand what I wan't to accomplish I have a column (A) with different zip codes ( total of 3583 rows). I need a formula/function to go through each cell and ...
0
votes
1answer
277 views

How to create a formula that can count values across multiple columns in specified rows

I have an Excel sheet where I have multiple tasks and multiple products. Each task for each product is rated red. amber or green depending on progress so far. Each task also has an owner. I want to ...