All Questions
64
questions
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 ...
5
votes
2
answers
4k
views
How can I create a reusable function in Excel 2007?
How can I create a resuable function/formula I can use in formulas in a spreadsheet? In particular I need a very simple DateDiff formula and would like a way to encapsulate this function:
=(((HOUR(...
5
votes
4
answers
6k
views
Excel annoyance: How to maintain formulas in a ledger?
A common use of Excel is to create a spreadsheet which functions as a transaction ledger of some kind, where one or more fields in each row is calculated by adding a value or values from the current ...
3
votes
4
answers
21k
views
Copying Chart to Another Sheet with Updated References in Excel
I have made a chart within a sheet in Excel. Within the sheet, the chart refers to specific cells in the sheet to display (i.e. cells that contain my data points).
I would like to know how to copy ...
3
votes
1
answer
248
views
Filtering over merged downwards cells in MS Excel-2016
Note: This question has been asked back in 2010 on this site here. And yet, I would like to post it one more time, showing what I did and what didn't work. Besides, Excel has changed quite a bit since ...
2
votes
3
answers
489
views
Getting the value in one column from a formula on another column in excel
I have an excel table that looks like this:
Date Original Actual
11/10/10 15 12
12/10/10 12 10
...
24/10/10 2 1
25/10/10 -2 ...
2
votes
1
answer
66
views
Proper Syntax for AND OR NOT Excel Formulas
I was practicing some basic formulas in excel. The last 3 I worked on are as follows:
=IF((OR(C4="Hourly",C4="Contract")),"Yes","No")
=IF((AND(B4=&...
2
votes
2
answers
2k
views
Highlight ONLY THE FIRST of all min/max values in a row/column in Excel
I'm trying to THE TITLE, that would be the general question; in my specific situation I need the minimum value in each row of a matrix, using conditional formatting of course.
I've only been able to ...
2
votes
1
answer
113
views
Formula inside conditional sum (Excel)
I have a VBA function, that check cells and returns an integer. (for example CheckThis(A5) => 23 )
How can i do something like this:
=SUMIF(A1:E1,Checkthis(N) = 23)
I tried various possible methods ...
1
vote
2
answers
98
views
Cover a formula in drop down list with a word
I have a list in Sheet2 J3:J7 of calculated values.
I would like to insert it as a drop down list into Sheet1 B10, which is simple enough, however:
I want the list to use the words: apple (J3), ...
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 ...
1
vote
1
answer
1k
views
How do I apply the MATCH() function only to a filtered range? Or is there another way to do that?
I have a filtered list of values. Let's say I have the numbers from 0 to 5, and 2 is filtered out:
A (with auto-filter against "2")
0
1
3
4
5
Now I want to find out whether one of the ...
1
vote
2
answers
2k
views
Formulas `A1:A` and `A1:Z` give invalid name error in Excel?
Selecting a range of definite size (e.g. A1:A2) works just fine, but selecting a range to the last row does not. If relevant, I am using Office 365.
1
vote
3
answers
1k
views
Extracting Text Between two Characters in Excel
I have an xls collumn with the following template:
Model : QE85Q80T,Diagonala cm / inch : 216 cm / 85 inch,Smart TV : Da,Format : Ultra HD 4K,Tip ecran : QLED,Rezolutie (pixeli) : 3840 x 2160,Tuner ...
1
vote
1
answer
350
views
Hyperlink does not change along with cell when filtered
I’m having a problem with hyperlink when using filters. So let’s say I have these table rows:
A
B
C
I have a hyperlink to cell C using the usual hyperlink option. But if I change the filter from “A to ...