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

learn more… | top users | synonyms (5)

0
votes
1answer
72 views

Count the numbers of matches between a row and a column in Excel

I have a data set in which I need to count the number of matches between any ID numbers in a column and equal ID numbers in a row. I have attached a data set example image and hopefully that will ...
0
votes
2answers
25 views

In Excel 2013 show cells as empty or blank until data is entered in other cells

What formula do I use to show Column C as blank until data is entered into Column B5,B6,B7, etc.? The formula I now have shows: DATE AMOUNT PD BALANCE 8/14/2015 $572.82 $572.82 ...
0
votes
2answers
98 views

Excel - For each unique ID, every time a particular column turns one, it needs to be cumulatively added

I have a big data set. What I want to happen is for each customer number occurrence, when the transaction type column has an entry CC or SO, it needs to be calculated as a donation. So for each ...
0
votes
2answers
71 views

How would I track loan payments in Excel?

I'm going to lend someone money, using a standard amortization model. There are a billion (well, like six) templates in Excel to calculate the amortization schedule. But this is for a loved one and I ...
1
vote
1answer
36 views

Excel automatic “date changed” field for each column of data

I'm using Windows Excel 2007, if that matters, and I'm trying to have a date field update to today's date automatically only when a cell in that column gets changed. I add new data entries per column ...
0
votes
1answer
33 views

Convert a column B into a comma separated list , “ORDER BY” Colum A

trying start with VB in excel just need understand how it works , this task can be done in SQL, but I really want to know how can be easy done in excel column A contains par numbers , column b models ...
0
votes
0answers
20 views

How to automatically populate worksheets?

Using excel 2016 i want to be able to be able to populate all of my worksheets automatically daily from one master worksheet with out having to enter the same repetitive data.
1
vote
2answers
38 views

Calculate the minimum starting from today (excel)

I am trying to get excel 2013 to display the minimum for a structured table but only from rows that are dated today or after. The table is a standard structured table, and most of the formulas I have ...
0
votes
0answers
21 views

Auto Update data from one column in Excel file A to another column in Excel file B

I have 2 excel files for example myemployee.xls and salary.xls. In myemployee.xls, I have two columns: employees code and names like this and new employees will be entered here continously. A ...
-1
votes
1answer
20 views

Excel List Lookup

I have two lists. I'm trying to write a formula, so that excel will look in one list to see if it can find any of the information in the other list, and if so, it will display X. So that if anyone of ...
0
votes
1answer
65 views

How to compare the Values in two different columns if the Values are same get the values

Column B has Values of customer Number (multiple times) till Row 1000 and column A has the sales orders information like below. Column A Column B ORDER1 KRISHNA ORDER2 RAVI ...
0
votes
0answers
21 views

How to use cell location from another worksheet

I have worksheet "Transactions". In row 2, I have a value of "SOLD". It will always be in Row 2, but the column floats due to adding or deleting columns. In worksheet "Income Tracker", I want to ...
0
votes
1answer
47 views

How To Return the Three Letter Month Abbreviation of a Date in Excel 2010?

I've searched here and other site without being able to find a solution. I've been able to do this in the past but can't figure it out now. I have an Effective date in, lets just say cell B1. I want ...
0
votes
1answer
31 views

Combining SUMIF and SUBTOTAL

I have looked at each of the other posts regarding combining these two functions, but I don't understand them enough to apply them to my specific task. I have to manually create an AR aging for a ...
0
votes
0answers
37 views

Select specific cells in Excel

I have an Excel 2010 spreadsheet with thousands of rows and columns. I want to select specific cells from it. Is there any way to select: every 7th cell in a column every 7th cell but restart the ...
0
votes
1answer
34 views

Excel Formula COUNTIF Issue

This is what I have for my D2 cell: =COUNTIF(B1:B50="yes",=SUM(A2)-1),IF(OR(C1:C50,"yes",=SUM(A2)+1)) Basically what I'm trying to accomplish is this. I have =SUM(A2) in my E2 cell for it's ...
0
votes
0answers
30 views

excel 2013; using if function, punctuation in true statement shows up even when value is false

In Excel 2013, when using the if function, and when the value if true contains & and punctuation, punctuation shows up even when false. i.e.: (CONCATENATE("Actual ",TEXT(X13,"hhmm")," - ...
0
votes
0answers
21 views

How to reconcile various fields in excel from different worksheets

I ran into a problem in trying to reconcile some data. (Worksheet A) Date Reference No.(1) Reference No. (2) Amount Name (Worksheet B) Date Reference No.(1) Reference No. (2) Reference .No (3) ...
0
votes
0answers
16 views

Formula in Excel which allows me to identify equal values in rows

I want to build a formula in Excel 2010 which allows me to identify EQUAL, GREATER or LESS values in rows. if column A is greater than column B or C (put the word GREATER in column D) if column A ...
0
votes
0answers
13 views

Possible to have template folder that has referenced worksheets inside?

It's hard to explain what I'm trying to do, but I would like to create a folder template that would have a bunch of smaller Excel spreadsheets that are referenced to a larger, master copy that has a ...
0
votes
0answers
34 views

Find text with multiple instances of character(s)

In this you can see that there are two types of cells. One contains order with one pair or brackets and second one has two pairs of brackets. For cell which has only one pair of brackets i use ...
0
votes
1answer
25 views

I would like excel to highlight a cell based on vlookup if then statement

I deal with contract changes every month. Each month I have to account for the money changes that happen with those contracts. I keep a running spreadsheet of each time I make a change that will ...
0
votes
2answers
40 views

Excel: Separate empty cells from having 0 value

I wanted to know if there is an option that doesn't allow empty number cells to obtain the 0 value when there is a function that takes values from these cells. For example, if I want to add the ...
0
votes
1answer
90 views

excel macro - how to delete rows based on a cell value

I have the following spreadsheet **Columns a-i** A B C D E F **G** H I **Row 1** 003 His Dressing 3305 S4S 0 0 **35** 35 1 ...
-1
votes
1answer
39 views

How can I make the value of one cell change, based on the value of another cell?

I am writing an inventory list for my office, which is combined with a borrow list. What I want to do, is change the number of items in the inventory list, once an item has been borrowed. For ...
0
votes
0answers
17 views

Compare 2 columns As in 2 separate sheets and if they match add column Bs from each sheet together

I have 2 separate sheets with 2 columns. I am looking to match Column A from both sheets and add the value of column B to each other and input the sums in a different column. looking for help. ...
1
vote
0answers
19 views

Cell auto adjust height when pulling data from other cells?

I've built a spreadsheet with a summary report that auto formats fine, except in situations where the text in one cell and is too long to fit into a cell. The report pulls info from cells under ...
4
votes
2answers
206 views

Bizarre COUNTIF/COUNTA behavior in excel for counting text cells that are not “”

I have a column of cells filled with formula that give "" on error, and a text string if no error. In a second column I'm giving a formula with: =COUNTIF(range,"<>") as well as: ...
-1
votes
1answer
66 views

Excel - Lookup value in column and return values from the same row

I was wondering if someone could help me with the following. I have 2 spreadsheets in a workbook. From the table in sheet1, I would like to lookup everyone that's enrolled in the workshop "7 Habits ...
0
votes
1answer
27 views

Counting words in a noncontinuous range in excel 2010

I need to count how many times a person's name appears in a noncontinuous range in excel. I used a formula on a different sheet that worked as it only looks at a column, but I need to look at ...
0
votes
1answer
34 views

Changing Excel Cell colours once a word/value in another cell is entered/changed

I currently have a spreadsheet with a list of deadline dates in row C and status updates in row E. I need the cells in row C change to green once the words Complete/ Completed is written in any of ...
0
votes
1answer
72 views

How do I implement the VBA module to copy filtered data

I need to implement a VBA Macro that copies data from one excel worksheet and puts certain column into another one. Sub sbCopyRangeToAnotherSheet() 'Method 1 Sheets("Sheet1").Range("A1:B10").Copy ...
0
votes
0answers
20 views

Matching data in Excel

I have two columns of stock codes - column A has no prices on it - column B has the prices beside it in column C. I want to index column B and search the code in Cell 1 of Column A for the same code ...
1
vote
1answer
66 views

How to use vlookup to look up words in Excel?

Here is a mockup of my data: Column I has categories of food and column H has the codes for those categories. Column E has sub-categories, which is what I need to work with. It contains the ...
0
votes
0answers
18 views

Excel: Reference a number in a concatenated string

Below is my formula in cells B7, B9, and B11 for three separate ranges of numbers: B7 = C6:N6, B9 = C8:N8, ... . B7 = "Average: " & round(average(filter(C6:N6,C6:N6>40)),2) &" Total: " ...
0
votes
1answer
18 views

Expand colour of formatted cell to rest of the row in a table

I have applied conditional formatting to several cells in column A, whereby if I type 'I' this cell will turn grey. What I want to also happen is that colour to expand into column B-I without changing ...
-2
votes
1answer
21 views

IF formula to compare several cells

Having problems with "IF" in Excel. I want to compare Cell A2 with cells B2, B4, (...), B100 from another sheet. How do I write the formula?
0
votes
0answers
13 views

Finding a way to auto update a formula based on real dates in excel

I'd like to track my employees vacation time with Excel. I'd like to be able to develop a formula that "gives" each employee 8 hours of vacation time once a month, based on their start date, and then ...
0
votes
0answers
15 views

Count values in another table matching a cell value in row of current table

In excel 2010 I have a table of projects, and a table of initiatives (one project to many initiatives). I would like to create a "total initiatives" column in the project table that counts initiatives ...
0
votes
1answer
62 views

Index match on 2 conditionals?

Data: I could use some help coming up with an index match formula based on 2 conditional items. For the attached data set, I need to set up a formula (and make it repeatable for other stores and ...
6
votes
2answers
416 views

How to generate random string from a set of available strings in Excel?

I want to generate a column which will have random string values in any order. Those string values have to be from ('New', 'Mint', 'Very Good', 'Good', 'Acceptable', 'Poor') strings? Can anyone let me ...
0
votes
1answer
29 views

Read last known value in a Excel data table

I'm working on something but can't figure out a formula and wondered if anyone out there has any suggestions? I'm looking for a formula which will tell me the last status of a job. In the example ...
0
votes
1answer
31 views

Need to transfer a column's data. I have 2 sheets with same data and need to move corresponding data from one to another

I have 2 excel sheets and both have one column that has matching data. However Sheet2 has a column of data that Sheet1 does not have and I need to input the corresponding data from Sheet2 into Sheet1 ...
0
votes
2answers
29 views

The IF function in Excel is not working?

For example: D1=3, D2=5, D3=3.5 I type the formula D1<=D3<=D2 which is obviously true but excel keeps telling me its false and then proceeds to mess up all my other formulas. But if I ...
1
vote
1answer
82 views

Excel.. using INDEX and MATCH to find a string in duplicate values?

I need a formula in Sheet1!C2, maybe a combination of INDEX and MATCH to find out, using ID field as a key, if a certain ID bought screws (sheet 2). My problems are: ID is duplicated in sheet 2, ...
0
votes
0answers
27 views

MS Excel - Match match index?

Sorry in advance if my formatting or question is hard to follow. I'm kind of new at this. And couldn't figure out how to do table format... I have an Excel table laid out kind of like this: (ID#) ...
2
votes
2answers
79 views

How to flag rows with the pattern non-blank, blank, non-blank using Excel

I would like your help with something I have been trying to figure out for the past two days. I have data with 1000's of rows and several columns. I want to insert a column with a (array) formula ...
0
votes
0answers
39 views

Excel drop-down list formulas

I'm trying to create a smart Stats sheet in Excel 2013 (PC) using drop-down lists. In Sheet 1, Column B contains similar drop-down lists with the following two choices: Project and Regular Work. ...
0
votes
2answers
63 views

Combining numeric values that have been converted from text

I built a survey tool that our customer service agents use to track survey results. For ease, the agent simply chooses a survey value (text) from a drop down menu. There is data being collected from 5 ...
0
votes
0answers
7 views

excel sheet updating / copied sheet isn't

my excel spreadsheet is set on auto calc. The original sheet is updating when I make corrections. The sheet I have copied into my financial workbook (with the same formulas in it) is not updating ...