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

learn more… | top users | synonyms (5)

0
votes
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
2answers
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
2answers
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
1answer
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
1answer
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
0answers
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
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
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
2answers
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
2answers
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
1answer
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
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
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
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
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
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
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
1answer
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
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
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
0answers
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
0answers
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
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
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
1answer
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
1answer
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
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
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
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
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
1answer
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
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
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
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 ...