I am able to use
COUNTIF(A:A,"2 months")
to find all cells in column A with the value "2 months".
I would like, however, to be able to count all cells that contain the word "month" or "m...
Hi,
my customer reports that they can open same excel file for editing with other users (same time). Usually Excel would open it as read only because it's already opened by other user.
S...
I need to delete all rows in sheetA --> where any cell in ColumnC contains Just "_" as value.
Can some one help me with a line of code for this please.
Regards
Hi all, here's my problem:
I have an excel template thats stored on a server and used by multiple users on different machines. Inside the template, I have a button setup to print specific ...
Dear experts,
In Excel VBA I define dim ObjAss(100000) as variant.
Now I would like to assign 3240 to each cell of this array as its default intitial value.
Is this possible with looping th...
have the following formula which works great, however for orders over $20,000 I need it to return a service fee (the lookup value) of cell D6*.01. How do i add that on the end of this formula...
Hi,
I would like to use SUMIF (or equivalent expression, eg using arrays) to sum a column conditional on multiple other columns. The match columns are either text or date. The date conditio...
pardon the caps but every time i post all i get are answers regarding printing through the acrobat shell. I know how to do that!. These pdf's are opened automatically each morning via a macro ...
I am stumped on this one, hoping someone can help...
I have different product codes available in column E. For Example :
10S
10N
20S
20N
20SH
20NH
I want the sumproduct to check col...
I have rows of data with which I'd like to forecast the next 2 periods of data for. What is the formula to do this. I'd like to do this in excel all on one row as shown below:
Item P1...
Hi All
I have a huge data in my access table for which i need to do a pivot in Excel.
Since i cannot export the excel sheet (due to row size)
1. how to link the excel file to the Accessdb...
I have an Excel File that is 36MB and its in 2003 format.... I have tried to open this file over our Cisco VPN and it takes forever to open it, like about 10min or more.... I have tried openin...
Hello
I have a macro that is not working as expected.The macro is supposed to take, the original file name and add a sequence number to the existing filename. Is is supposed to sequence up to...
Dear Experts
I am trying to dynamically range name "Currency Array" as below. I have counted down to row 13 using CArow and I start at cell C6. I would like to range name from C6 to C13. ...
In the attached excel sheet sample file I have inserted a cacluted Fields (highlighted in yellow color) in the Pivot as
"Sum of Percentage_Completion"
How to display the values are perc...
I have an imported data column with thousands of records that looks like this in no particular order (I think ordered by import date):
Column URL:
www.site.com/browse/-/-/usa:ga:valdosta/?...
Hello,
I copy and paste a header into a DIFFERENT file several times per day. The file I am pasting the header into is always the same format but different data, so the header is always the s...
