All Questions
64
questions
1
vote
1
answer
183
views
How to get Excel to extract information for a given date without duplicates and skip empty cells?
So I have a table which contains companies that a group of people will visit on given dates. I'm trying to make a formula that will have index for the companies and match it for the given date. When ...
0
votes
1
answer
205
views
Ticket report - Auto populate from other worksheets into specific form
Hello ladies and gentlemen, I'm quite a dummy in excel and programming in general and I have a question related to building a report:
I must present a ticket report of which tickets are opened, how ...
1
vote
1
answer
499
views
Excel | How Can I Increment A Formula By 1 For A Group Of Formulas
Currently what is happening is that Im attempting to increment the formula +1.
for example here is what is in b1-b4:
Cell | Formula
b1 | =(mark!A8)& " - "& (Config!A4)
b2 | =(mark!A8)&...
0
votes
1
answer
73
views
Excel TODAY() function
I have two tables in excel
The first table is called Oranges, it shows where the oranges were produced and where they were exported to:
The second table is supposed to show the total oranges shipped ...
0
votes
1
answer
2k
views
How do I convert sql to excel syntax?
I have two sheets in an excel file, "sheet1" and "sheet2".
The first sheet has a table called Oranges, it shows where the oranges were produced and where they were exported to:
On the second sheet I ...
1
vote
1
answer
52
views
Grouping sums in Excel [duplicate]
I'm currently doing dissertation work which requires me to average 95 pieces of tidal data for a month. I have all my data, but averaging them is turning out to be a tedious pain.
I have 95 points I ...
0
votes
1
answer
861
views
How to copy tab-contained text from Excel without quotes?
I've noticed that a cell that contains a tab is copied with quotes embedded. I'm looking for copying such kind of a cell without the quotes.
Illustrative Example
I've 5 cells; A1, A2, A3, A4, and A5....
-1
votes
1
answer
105
views
Excel CONCATENATE function produces error when referencing a worksheet with space in name
In Microsoft Office Excel 2013 on a Windows 8.1 PC, I get an error message, #NAME?, when trying to do the following:
=CONCATENATE('Calculation Sheet'!D, "- Customer Sales")
Doing the same with an ...
0
votes
1
answer
291
views
MS Excel | how-to SUM combination of array/absolutevalue
When using Microsoft Excel you can use the SUM function to add multiple cells, like so:
=SUM(A1:B7)
Let's say Row-A is an array set of numbers per cell (numbers totalled by formula) and Row-B is ...
0
votes
2
answers
381
views
How to sort columns in Excel so that only one value appears in each row?
Say I have a a spreadsheet with the following data:
A B C D
---------------------
2 1 0 2
3 2 1 4
5 3 3 6
7 5 6 8
11 8 10 10
...
0
votes
2
answers
129
views
Excel: Applying Condittional formatting to every other row
I would like to apply a specific conditional format to every second row in my spreadsheet. In my specific case I have regression results, where the first row indicates the beta coefficient and the ...
0
votes
1
answer
3k
views
Generate ordered numeric list in Excel based on cell value
I'm not sure if this is possible, but I would like to create an ordered numeric list automatically based on a cell value. For example, if I have a cell with a value of 100, I want excel to ...
1
vote
1
answer
4k
views
Displaying Other Values Via COUNTIF in Excel
Basically I have a sheet like this:
A B C D
Name (From File 1) Name (From File 2) Phone Number Countif
Walt ...
0
votes
2
answers
1k
views
If / Else logic involving text i Excel
I want to perform the following logic in a Microsoft Excel 2010 worksheet:
In cell E3: if C3 = Off or off then VALUE=0, else Value=C3*D3
Where cell C3 will contain either a number or the word 'off' ...
18
votes
7
answers
123k
views
Microsoft-excel newlines and tab
Current I use "CONCATENATE" to join string in Excel, but I want insert character newlines and tab in string joined by "CONCATENATE".
Example:
I've string below when I completed join string.
"Today ...