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

**0**

votes

**1**answer

29 views

### Comparing 2 columns and add blanks in 2nd column

I have 2 columns where some cells have the same value.
I would like to sort both columns and put blank cells to another column if it doesn't have duplication.
Example:
| Test1 | Test1 |
| Test2 | ...

**0**

votes

**1**answer

41 views

### Excel: Changing and updating a future value based on past occurrence and lookup in a table

I have a big dataset, dataset is in such a way that each time a customer is called a row will be created. So the customer Number is the unique ID here. Based on their current and past response type, ...

**1**

vote

**1**answer

60 views

### Get last occurrence in a list in Excel

I have a list in sheet1 and want to get last occurrence of each product right in front of it in bank page.
Here is the formula I'm working with:
...

**0**

votes

**0**answers

65 views

### Using IF statement to display an image

I have a problem displaying a picture (bit image) in Excel after checking for certain conditions in an IF statement. I also have a problem with using arrays in an IF statement.
For the below IF ...

**1**

vote

**1**answer

34 views

### Excel: Can I do sumifs with calculations?

I am doing some recalculations in Excel on a long list to prepare it for statistical analysis in other programs and I am having troubles with one thing I want to do.
I have a list of some variables, ...

**0**

votes

**0**answers

15 views

### Excel 2010/Hancom Automate the inserting process across multiple sheets

I'm in the process of creating a complicated excel spreadsheet which is where my knowledge runs thin. It's currently consisting of 17 sheets. I currently have 10 pages which require a daily entry of ...

**0**

votes

**0**answers

14 views

### Microsoft Excel 2007 for OC

I have a column with multiples of different answers, like the following:
Country
Germany
US
Italy
Italy
Germany
Germany
Germany
US
Italy
US
I want to:
list how many different countries are in ...

**2**

votes

**2**answers

102 views

### How to round down to the nearest 50?

I want to round down to the nearest multiple of 50 in Excel.
So if cell A1 = 318, I want to round it down in cell B1 to 300, and if A1 = 367, round down to 350.
Is this possible?
If so how?

**0**

votes

**2**answers

51 views

### LibreOffice Calc IF Function returns True when should return cell

I have been successfully using the IF function up until the last few days. I used this statement to return one of 2 values depending on whether or not an item is shaped:
...

**-1**

votes

**1**answer

28 views

### Display the last value in a data sheet of duplicates

I have a list of duplicate values and I need to display the last value in the data sheet.
In the example below I need to display that the code ER16 has a qtyleft (quantity left) of 4

**0**

votes

**1**answer

47 views

### Excel If Function With More Condition with Match Function

i had a problem with if function with more condition and match function. May i had Solution?
Currently I try using this array formula but cannot get any result.
...

**1**

vote

**0**answers

41 views

### Why doesn't Excel auto-adjust formula when a row is moved?

I have a simple spreadsheet with just one formula, which auto-increments the number in the first column, going from cell A6 down. So the value in A6 is hard-coded 1, then A7 contains the formula ...

**0**

votes

**1**answer

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

**2**answers

26 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

**2**answers

99 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

**2**answers

74 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

**1**answer

37 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

**1**answer

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

**0**answers

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

**2**answers

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

**0**answers

22 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

**1**answer

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

**1**answer

66 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

**0**answers

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

**1**answer

49 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

**1**answer

32 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

**0**answers

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

**1**answer

35 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

**0**answers

31 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

**0**answers

22 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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**2**answers

42 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

**1**answer

100 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

**1**answer

41 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

**0**answers

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

**0**answers

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

**2**answers

210 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

**1**answer

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

**1**answer

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

**1**answer

35 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

**1**answer

74 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

**0**answers

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

**1**answer

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

**0**answers

19 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

**1**answer

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

**1**answer

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

**0**answers

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 ...