All Questions
48
questions
0
votes
1
answer
324
views
Count based on multiple alternate conditions in Excel
I need a formula to count any trailers that are due in but do not have a cell that says "yard" or have a date next to that trailer. Please see screenshot. I tried the COUNTIFS formula and was ...
1
vote
1
answer
97
views
Formatting date from decimal in Excel [closed]
How do I format a decimal value like 1.30 as "1 year & 3 months" in Excel?
The value needs to remain the same but just needs to be displayed as 1 year & 3 months.
I need to do this just ...
1
vote
1
answer
215
views
How do I create a summary of the same few cells on many different sheets in Excel 2013?
I have an Excel workbook with 140 sheets. I'm trying to summarize the same 3 cells in each sheet on a summary sheet. How do I grab the value of the respective cells on each sheet without manually ...
1
vote
2
answers
605
views
Excel 2010 Array Formula (CSE) Dynamic cell range/reference; index? offset?
This might be an easy question to some but I am completely lost so I would really appreciate any help out there!
A
1 10
2 20
3 30
4 40
5 50
6 60
7 70
...
0
votes
1
answer
7k
views
How to Mirror cells in excel 2013 [closed]
I want to make an excel file for sales management of my company. the excel I have created has 4 sheets and every sheet is handled by different persons.
I want to dedicate the first column of these ...
2
votes
1
answer
305
views
Excel - Exclude Cells from Computation
Say I have 5 columns of data with 100 rows (so from A1 to E100). For each row I want to compute the averages of the 5 entries while I always exlude one of the entries. E.g. for the first row I would ...
0
votes
1
answer
3k
views
Conditional Formatting for one cell value in a list, another cell blank
Looking for how to do Conditional Formatting for the following rule:
If a number in a cell equals one of a list of particular numbers, then information MUST be entered into an additional cell. Both ...
1
vote
1
answer
3k
views
Dragging a cell reference in intervals
I have data as follows (simplified) in two worksheets on a document:
Sheet 1 data:
A1=1 -- B1=(Blank) -- C1=(Blank) -- D1=2 -- E1=(Blank) -- F1=(Blank) -- G1=3 ...
Sheet 2 data:
A1='Stage Plan'!...
0
votes
1
answer
2k
views
How to have excel paste a value in a specific cell according to another data table
I'm working with excel 2010,
I have an excel sheet with two tables. The primary table contains a calender and each calender day has a specific numeric value in the cell below the date.
The numeric ...
-1
votes
1
answer
4k
views
Updating another Excel spreadsheet from current spreadsheet
I used the VBA code in "How do you write an Excel formula that will paste a specific value in a different cell?" posted here in May 2013 and it works well to populate/fill another cell in the same ...
0
votes
1
answer
3k
views
Formula to display text from multiple cells from one sheet in another
I have a list of sales reps and the names of the customers they've sold product to, on one sheet. I have tried VLOOKUP, but it will only return one set of text from the cells. I would like to know, ...
0
votes
3
answers
470
views
Excel - Referring to a certain cell based off of data in another
I have a spreadsheet where there is one table with the headings:
Coordinate, Lat, Long
Another with headings
Triangle, Coordinate 1, Coordinate 2, Coordinate 3, Area
What this is for, is taking ...
8
votes
5
answers
239k
views
How do you write an Excel formula that will paste a specific value in a different cell?
So basically I want to write a formula that will check a condition, and if that condition is met, then I want to paste a specific line of text in a different cell. I should note that I do not want the ...
2
votes
7
answers
209k
views
How do you add extra value to a cell that already has an existing number in it
I find this hard to explain, but I'm stocktaking beers, spirits, and liqueurs and I want to keep one column for my ullage count for each product. However, as I go through the days, I often come across ...
1
vote
1
answer
2k
views
Call on a cell in Excel up to the first semi-colon
I am using the =CONCATENATE function, and one of the cells I'm calling on I only want to take the value in the cell up to the first semi-colon. Is this possible, and if so how?