Pages

Search

Excel Help Forum - Excel General: Problem with Record Count while in Filer Mode

Feed2Mail notification - new post on Excel Help Forum - Excel General
Problem with Record Count while in Filer Mode
Hello There, I got a small problem with filter mode. I am using excel 2003. I am in filter mode and the record count (When you filter a specific condition it shows the n of z records found at left hand side bottom) works fine for all except one condition. When I select the batch number 21...

Excel Help Forum - Excel Programming / VBA / Macros: using formula to generate values

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
using formula to generate values
I have a formula which is as follows: Code: --------- =12*NETWORKDAYS(B1,D1)-12+IF(NETWORKDAYS(D1,D1),MEDIAN(MOD(D1,1)*24,6,18),18)-MEDIAN(NETWORKDAYS(B1,B1)*MOD(B1,1)*24,6,18) --------- I want to copy this formula down my sheet until the last value in the D or B column however this makes...

Excel Help Forum - Excel General: Find criteria in range and mark the cellborders of found combination with color

Feed2Mail notification - new post on Excel Help Forum - Excel General
Find criteria in range and mark the cellborders of found combination with color
Hello, I need a solution for the following task: I have a range of numbers in a table D13:U54, the numbers in the table are 0,1,2,3,4 and appear random, e.g. D13=1 D14=1 D15=1 D16=2 D17=2

Excel Help Forum - Excel Programming / VBA / Macros: Internet Explorer Navigation

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Internet Explorer Navigation
Hi experts, It's my first time to create a module that will control/navigate an IE. Is there any tutorials or examples that I can ready/study? For example. I want to automatically input my username and password in a mail account. I have done it but I want a data validation, how can I...

Excel Help Forum - Excel General: Staining cells only text without any dates in Sheet1 itself, but taking a dat...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Staining cells only text without any dates in Sheet1 itself, but taking a date from the PC
Hi all, I have one for my very complex task imagine excel column A1: A10000: A1 to A10000 - have only text: A1 - something A2 - another thing and so on Now with my colleagues argue the following tasks and problems - he said I had (but lost it) only formula (at least in his own words) which...

Excel Help Forum - Excel Formulas & Functions: What formula to use for matches in column and return the sum of all match val...

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
What formula to use for matches in column and return the sum of all match values in adjace
Hello, I need help to find the appropriate formula to find all entries in a column (in this case C) and add all entries in an adjacent column (in this case d) each time the reference is entered. If my verbage is not clear let me know and I will try to explain better. Thanks, Mark

Excel Help Forum - Excel Programming / VBA / Macros: It's possible to create an "autorization" or reject button with vba excel?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
It's possible to create an "autorization" or reject button with vba excel?
Good Afternoon! Thanks for your answers, have helped me to go learning excel vba excel! ;) I have a question.. I'm working on a time system tracking, and I want to know if it's possible to have a button for authorization (and sent by mail to me) to authorize or reject the workbook.. Is it...
Subscribe to: Posts (Atom)