Pages

Search

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...

Excel Help Forum - Excel General: [SOLVED] help with formula. It works but empty cells show#VALUE

Feed2Mail notification - new post on Excel Help Forum - Excel General
[SOLVED] help with formula. It works but empty cells show#VALUE
I have attached a sample workbook and in it I have surprised myself by ammending a formula, it works but when the cell is empty I get #VALUE in the cells, I would like the cells to be empty. It's difficult to explain but it is obvious if you would take a look at my sample. Thank you.

Excel Help Forum - Excel Formulas & Functions: Value return from two column comparison

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Value return from two column comparison
Thanks to anyone who can help me! I work for a medical practice, and I'm trying to quickly find the payments of our contractual reimbursements based on the insurance name and CPT (procedure code). Hopefully I'll explain this clearly...I have a spreadsheet where I'm trying to get a return...