All Questions
4
questions
0
votes
0
answers
267
views
Can Excel only display the results from a FILTER, ISNUMBER, SEARCH formula and not the entire array of searched data?
I am creating a spreadsheet that can search an entire "Control" data table using two search boxes.
Search TextBox1 searches by UPI
Search TextBox2 searches by Zip
The two search boxes are ...
- 13
2
votes
2
answers
1k
views
Converting/transforming sum(A1:D1) into A1+B1+C1+D1 in Excel
So, the situation is this, I want to know if there's a way to convert the sum of a range of cells into the sum resulted from adding each cell, separately, as shown in the title.
For instance, say one ...
- 121
3
votes
4
answers
2k
views
Apply Names in Excel is bugged?
I see people had this problem back in 2005 and it's still not fixed.
In my sheet I have these named ranges:
A1 - "name1"
B1 - "name2"
C1 - "name3"
In some other 3 cells ...
- 2,487
1
vote
1
answer
4k
views
Insert columns, within a range, based on cell reference
So am trying to tell VBA to insert a certain number of columns between two other columsn based on a cell reference.
I've managed to get excel to insert columns within my range:
Sub INSERT()
Range(...
- 55