Search results

Hi Everyone, I got a question from a coworker, it's a little convoluted so I copied and pasted it verbatim. I'm thinking to solve this the formula should be a nested IF and SUMIF. Love to hear your thoughts. Please see below. --------- Trying to use some different functions. I want to...

Hi everyone. Question- is it possible to have the solver return more than one solution, without having to (consistently) change the constraints. For example: X + Y = 10 Current formula 5 + 5 = 10 Solver--> set cell to 10 (the formula answer) by changing X and Y. Constraints, X <=4, Y>=...

Hey guys... I thought I was done with this issue, but alas not so. The people I'm working with are wondering if this whole process (see above) can be automated into a macro. In truth I know zilch about VBA so like to hear what you guys think. Thanks, Dave

@Somendra Misra and @ Narayan Thank you both very much for your help!!! Especially Narayan, suffice to say you earned your 10th Dan when it comes to your Excel Ninja skills :) 'Preciate it!! Best, Dave

Narayan, Question for you (or for all the other Excel sage's on this site). I took a look at the file you sent, and the formula, looking for some translation. At the risk of looking foolish, would you mind explain how this formula works? I'm not that great at formula interpretation...

Hey Narayan, Very cool. I appreciate your help! I'll download the modified file and take a peek. Thank you very much!!! -Dave

Hey Everyone, Ugh.. I don't know if this is going to help, or hurt. Preferably help :) I heard from the client and here is the response I got (see Part 2). In order to make thing more legible. I'm going to condense everything into one post and upload a file that was sent. The content...

Hi All... Thanks for the feedback. I'll check in with them to get a bit more clarity. Seems like I wasn't the only one. ;) Stay tuned, Dave

Hey Everyone.. Real quick I get questions from my co-workers since they've anointed me "the excel guy". Lucky. Me. Anyhow--- here is one sent to me... copied verbatim. Can interpret this a few ways... curious as to everyone else's thoughts. See below in italics Can you give me an idea...

Ahh... Many thanks to both of you!!! 'Preciate it! :)

Hi everyone, question on time calculations. how do I figure out how many hours a person worked with an hour lunch in between? IE = start at 9 AM end at 5PM lunch = 1 hour The fun part is if the person works on a shift. Especially from PM to AM. Example, 10 PM to 6 AM with hour break...

Hey Everyone... once again thanks. I'll give these solutions a go and see what happens.

Hello all.... I have a spreadsheet with apprx. 50,000 vertical cells and need a formula that would average every 12 cells. How would I create one? Is this possible easily, or would a macro work better? If so, how would the code look? Thanks, Dave

@Luke M-- Thanks so much, I really appreciate it! Best, Dave

Hi Everyone, I'll try and be as succinct as possible on this one. It gets a little convoluted since this is one of those things "you need to see it, to understand it". But here goes. On one worksheet I have the following fields: Code Lookup Project SRF Project/Description...

Hi Luke... Awesome!! I appreciate your help! Best, Dave

Hello everyone.... I have a question when working with dates. I created a spreadsheet that uses two date, say the sign-up date plus 90 days. Easy formula, that cell with date+90. My question is when I copy the formula down with the auto-fill handle (no sign up date in adjacent column), I...

Hello everyone. I could use some help with Excel percentages. Plus I will do my best to be as succinct as possible. 1. I have 5 worksheets that I need to build a summary page for. Same format and formulas on the summary page as on all the worksheets. How do I do this for percentages...

Hey Sajan, Thank you very much! I appreciate your help. Best, Dave

Hello all.. question. Can you do a vlookup where the answer can be 2 or more answers. Example : This is the information I have and would like to come up with the information on the bottom. Factory Invoice Number | Invoice No 5462444 3399808 5462444 3399829 5462445 3398920 5462446...

Hi Guys, Thanks for all your help.. I truly appreciate it. @Colin- I'll give the paste special another go and see what happens. Odds are I screwed something up when I tried it :)- I'll give the above solutions a try. Have a great day everyone. Thanks again!

Hello All... Thank you for your responses, see below. @kaushik03-- I neglected to mention that I am familiar with the ABS function (sorry), but thank you for your help and the reminder. I appreciate it :) To answer your question I need to convert a large sheet of numbers all at once...

Hi Everyone, Question- I have a spreadsheet where I need to convert all the positive numbers, to negative numbers. Likewise the negative numbers need to be converted into positive... this is for the whole sheet, not just individual cells. Granted I can do the paste special, multiply trick...

@LukeM No doubt you have earned the title of Grand Master Excel Ninja. Many thanks, D

Hello All, Question about links. I am trying to create a link between spreadsheets that will add new cells inserted into a range. Normally I just copy the range, paste special, paste links no problem. Here is the twist. Let say you have two sheets (SH1 and SH2). If I copy a range of cells...