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

learn more… | top users | synonyms (5)

0
votes
1answer
13 views

How can I import a TAB delimited file with double quote text qualifier into Excel if a cell value already contains a double quote?

I am trying to import a TAB delimited file with the following format into Excel 2013 "Column A" "Column B" "tjc0056421151r" "I\gs]hü"nsf^f\F*lqog\düûWp" "tjc0058088269r" ...
-1
votes
1answer
27 views

How to insert a button in MS Excel?

Friends I am using MS Excel 2010 and I wish to insert a button in Excel sheet whose name should be ‘1 ADDER’ and I want that whenever I press this button, it should insert 1 in the cell of column A ...
1
vote
2answers
24 views

Excel - Find ID-related Value and fill in another workbook

I'm working in a small hospital in India having following problem: For a special drug we're having a list with DATE,ID,DOSE,DURATION,NEXT VISIT which we us as a daily working list (workbook 1), means ...
0
votes
1answer
23 views

Excel- find match between to columns but copy a different cell

I would like to be able to find matches between two columns in Excel. Lets say Column A and Column C. However Column A's values are linked to Column B. When a match is found in A, can it copy the ...
0
votes
2answers
26 views

Excel 2010 formula to delete repeated content based on value (instead of second highest the lowest)

I've read a Question topic about picking the second highest value. I need the same but a bit different: Excel 2010 formula to delete repeated content based on value Maybe it is a bit rude, but I ...
2
votes
4answers
48 views

How to identify duplicates within text in two columns in Excel

I have a worksheet where column A has various names in varying formats: A1   John Smith A2   Jones, Mary A3   Sally Gomez A4   The Gonzalez family Column B has similar data: B1 ...
0
votes
1answer
10 views

Find multiple cells with the same value in col A then search col C for a particular number

Say I have multiple cells in column A with the same value (e.g the number 22). I want to identify those rows then search for the existence of a particular number in column B (e.g. the number 10); ...
-1
votes
0answers
7 views

How do I link other workbooks to a master file?

I want to know how to link different workbooks, which have similar names. For example, I have one master file, which needs to get populated from various other workbooks (from different worksheets). ...
-1
votes
1answer
18 views

Extracting values from an excel table to build a graph

I have the risk register shown as an excel table. I want to extract the entry corresponding to a specific KRA value and plot its maximum on a graph. I need the method to be automatic so that any ...
0
votes
2answers
26 views

Excel - Dynamic Cell Update using multiple criterias

I would like to know if there is a way in Excel to create a cell that will display a value using a formula that will calculate the latest entry by date and campaign. If I have 3 columns DATE | ...
0
votes
1answer
27 views

How to search in column A for specific data and place an answer in column B (“Yes” or “No”) [on hold]

Using Excel for Mac 2008. Column A has a long list of comma-separated data in no good order. I want to find one specific set of words (set off by commas, such as "Level 2 Supporter") in each row and ...
0
votes
1answer
21 views

How to shift the data from one cell to another cell in excel?

Friends I am using MS Excel 2010 and I want As I type any value or word in a1 cell, it should automatically be transferred into d1 cell and a1 cell should get blank again. Similarly if i type any ...
0
votes
1answer
51 views

Excel colon in function

I am learning excel functions and modeling from Google and trial and errors so just want to clarify the following point to get my fundamental understanding correct: When it comes to colon in excel, I ...
-1
votes
0answers
28 views

Excel OR function with several criteria, how to make better?

I'm making an Excel document (for Mac 2011, ver. 14.0.0) with a drinks list, and right now I'm making a sheet where you can enter what ingredients you feel like using (up to four) and the sheet will ...
0
votes
1answer
27 views

How to automatic transfer the values in another cell?

Friends I am using MS Excel 2010 and I want As I type any value or word in a1 cell, it should automatically be transferred into d1 cell and a1 cell should get blank again. Please suggest me any way, ...
0
votes
1answer
29 views

How to highlight a cell when I double click on another cell?

Friends I am using MS Excel 2010 and I want when I double click on a cell say a1 it should highlight c1 cell. Similarly when I double click on a2 cell it should highlight c2 cell. It is possible by ...
1
vote
1answer
20 views

How to write a function once and have it update in many cells?

It often occurs that I write a function in one cell and then copy it into many cells. The copies then refer to their own correct rows. But if I change the function in the first cell the copies are ...
0
votes
1answer
34 views

Is there a limit on the number of rows a sum function can calculate in Excel 2007?

I am trying to sum a column of 50938 values in Excel 2007 but keep receiving a "#VALUE!" error. The cells in the column do contain formulas. I also tried to sum the column after copying and pasting ...
0
votes
1answer
24 views

Excel formula - is it possible to return a value adjacent to a list of values, depending if that list of values matches another list?

In Sheet 1, I have a list of document numbers (alphanumeric) in Column A, which have a corresponding title listed in Column B. I need to compare another list of document numbers (alphanumeric), ...
0
votes
1answer
18 views

SUMPRODUCT where the product is computed from the row

I have a range AG6:AS38. It looks like this: AG AH AI AJ AK AL AM AN AO AP AQ AR AS -------------------------------------------------------- 6 | 1 A B C D ... 7 ...
2
votes
1answer
10 views

Excel Autofill Linegraph with Time

I must admit that I am not the expert on excel, but I need help creating a graph with some data. In column A, I have over 500 cells filled with temperature values from a probe. Now, technically each ...
0
votes
0answers
7 views

How to consolidate information from different sources in Google Sheets [migrated]

So I have a Google Sheet with several sheets (tabs) in it, like so: Sheet 1 - Weapons Legend A B C D A = Date 5/3 John Sword 10 B = From 6/3 ...
0
votes
0answers
26 views

How can I identify filtered columns? [duplicate]

My file has many columns. its difficult to know whether there are filters or not and I have to scroll to the right to verify each and every column. Is there a formula to put in a cell indicating ...
0
votes
2answers
29 views

Excel formula to identify and group figures

I have two columns A and B In column A, I have figures in some currency say US Dollars. In column B, I have account codes to which the figures should be grouped. A B USd Codes 2,500 ...
0
votes
0answers
11 views

Formula in Google Sheets to lookup contents of another cell [migrated]

I'm trying to create a formula that brings back a certain cell depending on what another cell has in it. But the formula I'm trying isn't working. It's working for other things (what I thought was the ...
0
votes
2answers
44 views

How do you get excel to ignore zero or blank values in an Average?

I am making a spreadsheet to score recipe ingredients, averaging scores for quality of the ingredient, packaging, and accuracy of serving size, and then using that data to create an average for the ...
0
votes
0answers
22 views

SUMPRODUCT & ROUND

Is there a way to get the product of the array with conditions to round to the 2nd decimal place before summing? Current formula w/o rounding: ...
0
votes
2answers
24 views

How can I prevent changes to formula results after first use?

We have an Excel 2013 workbook that we use when we create new user accounts (column A for first name, column B for last name, column C for the password, etc.). First name Last name ...
0
votes
1answer
22 views

Excel Month() function does not detect some date format

I have a simple table like this in excel: The formula i used was =IFERROR(IF(LEN(B3)>0,MONTH(B3),""),""). I check if a cell is blank by using LEN, if so ignore, else, convert it to month no. I ...
1
vote
1answer
22 views

How to use a variable once, across the equation, in Excel 2007?

okay, is there a way to declare a variable inside a cell, without calling the cell name 3 times, across the equation(?)? I came up with this, to calculate the age from a DOB entered using the ...
0
votes
1answer
16 views

How to create a dynamic date title in excel 2010 using different tables and data

My friend has asked for help with an excel assignment and they have 2 tables, HRM and Data_Tables. Data_Tables has corresponding month numbers from 1-12 in column I from I3-I14. In J column there is ...
-1
votes
0answers
15 views

Add a cells content to another cell if cells at the top of the columns have only specific content

I already have a big part of this done thanks to another user, however I need it to go one step further please. I want to add the contents of cells in a specific row, based on a SUM formula. I want ...
2
votes
0answers
21 views

Taking an indirect reference in excel and making it a direct reference

For many somewhat complicated reasons -- it has to do with transposing columns and rows because of third party software limitations etc. -- I have had to use the indirect function in order to make ...
0
votes
1answer
28 views

Simple sum of dropbox values for scoring Excel 2013 worksheet

I would like to make a worksheet with dropboxes for scoring ingredients and summing the scores per ingredient. I already made the dropboxes with number 1-3(1=poor, 2=fair, and 3=good), but I would ...
-1
votes
0answers
16 views

How can a cell be displayed if another cell is marked?

I am a trainer for an organization, and we have a major conversion to a new core system coming up. We have been provided a massive spreadsheet listing all the training modules that each person must ...
2
votes
0answers
22 views

How to output a CSV file from a matrix of Excel formulas using multiple files?

I am receiving on a weekly basis a list of Excel spreadsheets from a supplier (around 40 spreadsheets) with data in a specific format. Since the format is a bit complex and can't be converted to CSV ...
0
votes
2answers
41 views

Check if a cell contains any of words from a dynamic list

I want to use a formula to populate the "RESULTS" cells. I need it to check if the adjacent "CHECKED CELL" contains any of the words listed in the "KEYWORDS" cells. Ideally, I would be able to add ...
1
vote
1answer
16 views

How to create a text mask in Excel 2007

I have a list of numbers: 59046 64940 77505 101409 140331 1036135 3166909 I want every number to be exectly 9 digits. For example, i want 59046 as 000059046, 1036135 as 001036135. How can i create a ...
0
votes
1answer
31 views

Attendance Tracker - Deduct points if no points within pay period

I have a spreadsheet where I keep track of whether or not someone called in, was late or left early. On the 1st sheet I have their names, the number of times they've called in, were late or left ...
0
votes
1answer
8 views

Hyperlinking or linking in another way to a cell without it being able to change

How do I hyperlink or link to a cell from another cell in a way that when rows are added, and the row numbers keeps changing due to new rows of information being added throughout the sheet, the link ...
-2
votes
1answer
23 views

Add a cell content to another cell if a different cell has a specific content

How can I fill a cells value (e.g row 29 col A) with =sum(B1:Z1) but then only add the content of a cell in that row 29 if row 4 of that column says "UK IR". That way I can add all the cells together ...
1
vote
1answer
18 views

Sumifs function where I want to sum a range not just a single row or column

I am stuck. I am entering timesheet date into an excel sheet: Column A - Resource Name Column B - Project Phase Column C - Resource Team... Column D to AAA is a date Therefore a single resource could ...
0
votes
1answer
38 views

Multiple Formulas in one Cell for hotel

I am trying to create a housekeeping spreadsheet where when a room number is entered into a cell a 0 or 1 (0 is for studio and 1 is for a 1 bedroom) is automatically populated in another cell. I have ...
0
votes
0answers
11 views

Dynamic Values in a formula? [migrated]

I have a google sheet where I am using this query to pull data from another sheet : =QUERY(IMPORTRANGE("SHEETLOCATION","Master Customer!A1:u10000"),"Select Col3 Where (Col18='Survey Complete' and ...
0
votes
1answer
25 views

MS Excel - Cumulative sum of a column based on “id values” in another column?

I have been trying to figure out how to make a formula that calculates cumulative sums of rows in a column based on their id values in another column but still haven't found any solution for it. I try ...
0
votes
1answer
21 views

Grab cell data and use in “IF” statement

Is it possible to grab a cell containing a date and paste that date in an "IF" statement containing text, similar to the below: ...
1
vote
1answer
45 views

How can I replace forbidden characters in a file names before saving in VBA?

This will be very simple for somebody who knows VBA better than me. I used a code original provided by user Nixda on this forum to split excel worksheet into multiple CSV files based on column value ...
0
votes
1answer
36 views

SUMIFS w/ multiple Criteria

Base on the Emp ID and the Pay End date I'm looking to sum up the Total Earnings and if it is equal to or higher than the WC Cap in the exposure column I'd like to return the WC Cap value. If it's ...
0
votes
0answers
33 views

How to Sum based on two critera, date range and name

I have a table that has timesheet data for a number of users. Column A has the resource Names. Row 1 contains each week of the year, starting with the 5th of Jan. The table contains hours booked by ...
0
votes
0answers
25 views

finding the difference between two times in libreoffice

I'd like to know how to solve the problem: in cell A(n) is the first time in cell B(n) is the second time in cell C(n) is difference of times I don't want to put each time into cell C(n) function ...