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

**1**

vote

**0**answers

21 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

29 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

19 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

10 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

12 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

46 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

**1**answer

20 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

16 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

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

**0**

votes

**0**answers

27 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

30 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

16 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

**0**answers

17 views

### Create Round Robin Crosstable With Excel

I have a very large crosstable (120x120 at least) in Excel. The data is contains win or loss info. So, all data on row 5 and column E (which I label as column 5) contains data on the games the person ...

**0**

votes

**2**answers

41 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

50 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

17 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

25 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

18 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

29 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

12 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

19 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

25 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

18 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

**0**answers

9 views

### Where can I find documentation of the syntax for creating user-defined functions in NeoOffice Calc?

I'm trying (for the first time) to create a user-defined function in NeoOffice Calc. Unfortunately, I cannot find a reference source explaining what programming syntax should be used in the "Basic ...

**0**

votes

**0**answers

22 views

### How to make 2 Excel sheets read each other and combined into 1 excel sheet

I have 2 Excel Sheets with gas card numbers and date stamps on 1 and another with date stamps and driver names. I need to know if there is a way to have the first sheet read the second and combined ...

**0**

votes

**1**answer

35 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

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

**-3**

votes

**0**answers

23 views

### Excel worksheet coding needed

I need help changing this code
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim int_range As Range
Set int_range = Intersect(Target, Range("B:B"))
If Not (int_range Is Nothing) Then
...

**0**

votes

**0**answers

25 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

24 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

11 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

14 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

30 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

21 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

23 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

29 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

33 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

10 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

11 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

152 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

51 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

21 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

22 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

27 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

45 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

15 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

19 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?