All Questions
7
questions
1
vote
1
answer
82
views
Custom Information Message for user based on another cell value
I am busy with an optimization spreadsheet which needs to display an information message, maybe similar to the Input Message for data validation (but I am open to suggestions). This message will be ...
0
votes
0
answers
47
views
how to compare 2 columns and if the value in A is higher than B, copy the value of A over B
I'm trying to compare 2 columns of similar data and would appriciate some help. i need to know how to do the following. I what to know how to compare the values in column A with column B, then if the ...
1
vote
0
answers
250
views
What is the VBA equivalent of using an array formula to calculate the max non-blank value of a range?
I have the following array formula in Excel: {=MAX((C9:C44<>"")*(ROW(C9:C44)))} that calculates and returns the row number of the last non-blank cell in a range.
I could reference the result in ...
1
vote
2
answers
2k
views
MS Excel - Separate text based on keyword
I need to separate text based on a keyword to different columns. the original text is in one column but I want to split the intended subtext into different columns. The problem in this case is I get ...
0
votes
0
answers
872
views
Splitting excel sheet into multiple sheets based on two columns
I have a table of 10000 rows X 50 columns. The table is all in one sheet and I am planning to split that sheet into multiple sheers based on values in two columns (columns number 5 and 1, ...
1
vote
1
answer
6k
views
Filtering by currency in Excel
I have this situation in Microsoft Excel:
Cells are formatted by using "Format Cells" and setting the Currency manually for each cell. So, they are not simple strings. I would to sum filtering by ...
4
votes
1
answer
7k
views
In Excel, doing a "Freeze Panes" on the right-most column instead of the left-most?
My understanding of Excel's "Freeze Panes" feature is that you can only freeze the left-most column(s), or top-most row(s).
However, I have a table where a very important column needs to be located ...