I'm having a brain freeze with an IFERROR to eliminate the #DIV/0! after a simple calculation and it's driving me insane... the formula is =(E108-C108)/C108 the result of course where there are zeros is #DIV/0!. I have tried a few variations unsuccessfully any help will be greatly...
I receive up to 25,000 rows of customer data per day and need help figuring out how to transpose some rows to columns and eliminate duplicates. I want to transpose columns G & H based on the identifier in column A. then eliminate blank rows if possible. I included 2 screenshots for reference.
ineed help to creat formula to count the cells of two columns containingspecific text, but it should also eliminate duplicates.<o:p></o:p>
ihave 2 colums with data and i want to count them searching for specific text,and formula should be able to eliminate the...
When I update a cell in one worksheet either "ghost" cells from another worksheet inside the workbook appear at the bottom or over top of where I am entering data. How do I eliminate this from happening? I can click out of the worksheet and back in and they are gone.
I am using the indirect formula to link information from another spread sheet. Whilst the formula does work there are 2 issues with using this:
1, The file is very slow and takes minutes to update as opposed to seconds
2, Unless the linked files are all open the formula result shows...
In the range A1:J10 I have a situation like this
I need to eliminate the empty rows (3, 4, 6 e 9) end shift the not empty rows on the left, so that no empty cells
I have tried something like this to eliminate the rows...
I'm trying to build a macro which has some function to eliminate the same value based on column. and here is my sample data
the result i want to display is like this
Hi, excel masters. I don't know much about macros and VBA but I know that this can be done. if someone would be nice to help me, i would be tremendously grateful. Thank you
here's what I want to achieve,
1. I want to eliminate all texts that have "KM", "Litres", "Liters"
2. I want to...
Greetings. I created macros in Excel 2003, but those macros now always trigger a security warning when I open the spreadsheet with a macro. Until recently, I could eliminate the security warning by creating my own digital certificate and then digitally signing the macro. That no longer works...
A fellow worker sent me a spreadsheet full of cells formatted in such a way that it makes it difficult to remove some of the spaces.
For testing purposes, here's the file:
Uploadfiles.io - remove all spaces.xlsx
In this example, I have this text string in cell A1: " 6403 "
I want to remove...
I want to eliminate everything in left after a word.
Example: Suppose I have below number
a) 123 # 456
b) 12 # 21
c) 1234567 # 7654321
The output which I require is everything after #, as :
Could you please help?
Thanks in advance.
I was given a macro for this but it doesn't seem to work. Hopefully someone can help.
column A will contain a list of telephone numbers entered in this format: (xxx) yyy-zzzz which is how it would appear in the formula bar if the cell were selected. I need a macro that would eliminate all...
I have a spreadsheet. Latitudes are across row 1. Latitudes are across row A. The lower case letters are values of some function. I would like to delete all the columns and rows in the spreadsheet except for those that are closest to .00, .25,.50, .75.
For example, this