Pages

Search

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

Excel Help Forum - Excel Programming / VBA / Macros: have a drop down list with associated values difference to be calculated

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
have a drop down list with associated values difference to be calculated
hi all! in the attached file you will find in cell K1 a drop down list of all possible start values and in cell L1 end values. i want the program to be able to have someone choose a start value say for instance A.3.3 ( which corresponds to Line 13's data.) and a stop value of A.6.1 (line 22's...

Excel Help Forum - Excel General: R1C1 reference style default checked - driving me crazy

Feed2Mail notification - new post on Excel Help Forum - Excel General
R1C1 reference style default checked - driving me crazy
Does anyone know how to permanently uncheck that option? If you click the MS button, then "Excel Options", then ""Formulas", it is the first option in the "Working with formulas" section. This being checked makes your alpha columns display as numerals. Not a big deal until you try to copy a...
Subscribe to: Posts (Atom)