I am trying to copy from Excel and paste elsewhere, and I am getting quotation marks (") before and after the selected text. Any way to fix this and not get them?
I am using =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=1)) to count the incidents that occur on a Sunday and =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=2)) for Monday and so on. They are working great, except for Saturday =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=7)). I am getting a value that is 9000+ higher than...
I have a formula that works great when the spreadsheet is empty, but when I start adding any data it presents an error.
Is there a way to add iferror to keep the cell blank until the cell has pertinent data?
O2#N/AO2O2=IF(ISBLANK(A19),"",VLOOKUP("tow",A$19:B$38,2,0))
I have an if formula that has a variable. I'd like to search for a keyword (diesel) and if it is found, return a string. I thought about IF(F23="*diesel",S$33 but that didn't work.
Any ideas?
The first 4 parts work, but none of the rest. Any ideas why?
=IF(ISBLANK(A19),"",IF(A19="tow","Towing",IF(A19="etow","Emergency roadside towing",IF(A19="itow","In house towing",IF(A19="inspect","Inspect to determine necessary repairs",IF(A19=”dot”,"DOT re-inspection fee",IF(A19=”scene”,"Clean...
Hello everyone,
I recently ran an experiment that required participants to select exactly 35 out of 100 squares on a 10x10 grid. I now need to calculate the mean of all possible pairwise distances between the 35 selected squares on the grid.
I have attached images of a file that has two tabs...
If I add a new column A, that changes all of my other formulas. Is there a way to add a new column (every 2 days) and have it add the new column in the formula?
Example. I have in M2 a formula: =COUNTIF(A$2:C$30,L2)
But, when I add a new column A, the new formula will be =COUNTIF(B$2:D$30,M2)...
First Name
Last name
Suffix
Complete name
Last, First
Phone
DOB
Hire
Term
SSN
Tenure
Phone
SSN
Age
john
doe
jr
John Doe Jr
Doe, John
8158675309
5/21/73
11/28/2017
123-45-6789
2 years, 11 months, 5 days
(815) 867 - 5309
6789
47
If I enter a date in the term column (j2) is there a way to...
I have dates in w24 (start date) and w26 (end date) with the resulting math taking place in w28. Easy enough.
The issue is I need to not calculate the weekends. I tried the workday function, but that isn't what I am looking for... Any ideas?
I have a spreadsheet that has my driver's names (and other data) and another spreadsheet that I use that data for.
When a driver is removed from the driver data spreadsheet, I receive an error on the other sheet...
The formula works well until I remove a driver.
The formula I use:
='[N&I...
I am trying to replace "Selection.PrintPreview" with "Application.CommandBars.ExecuteMso ("PrintPreviewAndPrint")" but I am missing the "Selection" component.
How do I preview the selected range with the new print preview window?
Hello,
I'm stuck in one of the business use case where we need to add duplicate entries in a new custom table from the inputs given in other table.
e.q. consider i have a table with
Subscriber
Effective_date
Expiriation_date
Service_Code
Now i want to dynamically create a custom table...
Hi,
Perhaps this is a straightforward one for you experts here....
I'm trying to find the best way of building a product selection tool for around 3-500 Adhesive Tape products. These are quite technical and have many criteria associated with them. For example:
Adhesive Thickness Side 1 & 2...
I am somewhat new to VBA, I have created a userform that will open a word document and update several lines of text within the document before saving and closing it. I know that it is possible to insert text at a bookmark, but I do not currently have the understanding to do this. My code is as...
I'd like to know what kind of formula/what is the formula to have Excel figure something like this out:
Say
A=7
B=12
C=30
D=Scaling(1-100) Like a unit's level
And it will make Q=((A*B*C)+(C*D(also D-1, etc)) like an Arithmetic progression. Where D is Q/((A*B*C)+(C*D(also D-1, etc))
So for the...
Hi all,
I am trying to copy an example from a textbook so that i can edit it for my own use and i have typed out the Macro they apparently used. i Have checked a few time and can't see the error but i keep getting a 'invalid control variable reference' error and can't get any further. I would...
What is the keyboard shortcut for highlighting cell? Can a frequently-performed task be assigned a keyboard shortcut by user? If it is done by VBA, please post the code.
Thanks.
Legacy 232375
Thread
highlight
keyboard shortcut
thanksinadvance!!!
user defined
vba
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.