All Questions
693
questions
0
votes
2
answers
4k
views
Trouble using IFERROR with an IF statement that has Multiple Conditions
I have a nested IF formula. The return value for some of the IF statements is given by index-matching. If the item doesn't exist on the other sheet, the index-match returns a #N/A, but if there's an ...
CommunityBot
- 1
2
votes
2
answers
10k
views
VBA: How to replace entire Excel cell value basing on its content?
I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell.
For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...
CommunityBot
- 1
0
votes
2
answers
5k
views
How to modify these VBA codes to save excel sheet in excel format (.xlsx)?
I have added a button in excel sheet and now when I click that button it saves the sheet at specific path with specific name but in pdf format.
I want to save this sheet simply in excel format (....
CommunityBot
- 1
0
votes
3
answers
8k
views
In Excel replacing a column with another column
I have a list of Variables in Column A > list of items
another list of variables in Column B > with corresponding Item Codes for >> column A
And in Column C > I have list of item codes randomly ...
CommunityBot
- 1
1
vote
1
answer
4k
views
References to blank cells become 0's
I have a spreadsheet in excel where I need to make some references to an area in another spreadsheet. I simply use ='EARTH'!B9:N323, which is an area mixed with some columns of text and others of ...
0
votes
1
answer
2k
views
Formula to ignore or treat as empty a cell that contains another formula with no result?
I'm using Excel 2007
I have a Cell B14 which contains a formula getting data from a different worksheet and sometimes this formula may have no result.
I need a formula to ignore Cell B14 or treat it ...
- 1
0
votes
1
answer
80
views
In Excel is there a way to “turn on and off” the =min in a formula?
I am creating a budget spreadsheet in Excel and in some instances I will need the formulas in the spreadsheet to include the =MIN and in some instances I won’t. For example, the formula is:
=MIN(...
- 1,661
0
votes
2
answers
8k
views
Adjust sequence position of barcode scanning result
I've been improve our warehouse record method by barcode scanning.
But the problem defaut scanning result inside excel format is after scan cursor will move to below cell ( ex : A1 to A2 to A3 etc).
...
CommunityBot
- 1
4
votes
1
answer
183
views
Consolidate Data from Multiple Columns into One Column
I have a dataset that looks something like this:
Customer
Col1
Col2
Col3
Bob
111
2221
Michael
112
Anna
113
2223
Rachel
114
2224
334
Person5
115
I'd like to put all data into one column, ...
- 2,593
2
votes
2
answers
6k
views
Excel: Complete row Hash Value calculated as a Numeric value in a cell on same row
I have to manage "Change Control" on Excel spreadsheets comprised of 1000's of rows and dozens of columns.
Downstream Teams often submit revised columns that I have to incorporate into a master ...
CommunityBot
- 1
1
vote
1
answer
4k
views
How to use if statement to merge cells depending on selected value
I am a photographer and I want to create a weekly time sheet for my photo shoot bookings. Some sessions are 1 hour long, some are 2 hours, 4 hours... etc. So I created a table and a dropdown list ...
CommunityBot
- 1
2
votes
2
answers
4k
views
Lookup multiple results for multiple criteria
I've got a list of parent SKUs for items I need to create in my inventory system. This list has been finely paired down to the 165 products we would like to carry. However, each one of these 165 SKUs ...
CommunityBot
- 1
0
votes
1
answer
5k
views
Hide sheets in shared excel workbook.
I have a shared workbook on which I have hidden some of the worksheets prior to saving.
I have closed the workbook. If another user opens the workbook the worksheets I had hidden are visible. If I ...
CommunityBot
- 1
0
votes
2
answers
70
views
Copy paste the values of cells from Excel
I want to copy paste the cell values what we see post pressing F9 in a cell into word. Is there any short and quick way to do this?
For example - if I have a formula:
=AVERAGE(E12/H12,E11/H11,E10/H10)
...
- 2,310
0
votes
2
answers
4k
views
Increment Number within a Concatenated String based on conditional if
I am trying to Increment a Number based on a conditional IF in another column.
In Column A I have a =Concatenate("ABC","_",D2).
I am looking to fill down a formula that will basically be an =...
CommunityBot
- 1