hoping

Hi All, Hoping you can help me please, I have several combinations of product codes that I want to change so that all share the same format. Results should be to keep the first 2 letters, Next a 4 digit number, so in some of the below examples 53 would become 0053, or 331 would become 0331...

I am hoping someone can correct my nested if statement belowto work properly. I am sure I am nesting incorrectly with using (AND( in themiddle of my formula. I could use the VLOOKUP but I am hoping to avoid it ifpossible. From what I have searched online it appears the AND or OR statementsseem...

I have the following equation: =IF(AND(S19="yes",$V$5>0),VLOOKUP(I5,Table27,5,0),VLOOKUP(I5,Table27,4,0)) I'm having trouble adding to this equation: if S19="no", return a value of 0. Hoping explained my self and someone can help. Thanks Alex

I have an Excel dilemma I am hoping to get some eh

Hello everyone, I hope you all are having a nice day. Myskillset with Excel is intimidate best I currently own to 2016 MS Excel book.And to give some additional backstory I would for a insurance company with acall center type environment . I am hoping to create a excel worksheet for the...

Hi I use the following formula which works well =SUMIF(CAR!$D$43:$D$907,$B4,INDEX(CAR!$H$43:$XFD$909,,MATCH(TODAY(),CAR!$H$42:$XFD$42))) How do i add the following 2 formulas to the formula above so it sums the 3 tabs? I am hoping for a single formula...

Hello all, I'm looking for a formula to convert the following: $1,234,567.89 to a text string that looks like the following: 123456789 It needs to en corporate the decimal, assuming the last 2 positions are cents. I'm hoping this is fairly easy and I just haven't had enough coffee yet to...

Hi guys! Basically am trying to work out how to make a formula that automatically calculate if a timestamp lands between the hours of 7:30am and 4pm. If it falls between 7:30am and 4pm I'm hoping for Status to say Business hours, If it falls between 4pm and 7:30am I'm hoping it says After...

Hi, Trying to add all of occurrences of "Yes" in a particular range for all worksheets. I was hoping to use the clever trick I use for summing across worksheets: =SUM(First:Last!$E$36:$I$36) I tried using COUNTIF or AGGREGATE (using 2 for COUNT) but I get #VALUE ! error...

Hello I'm a total novice excel user but have a need at work that I'm hoping we can use excel to solve. We need to create one place where 3 separate people can log applications taken from our customers - excel workbook. To that end, they all need a unique identifier that we don't want them to...

OK, I'm trying to add one final piece to an NBA spreadsheet I've been working on. On a separate sheet I have the name of every team, along with the average points they give up to each position. It looks kind of like this; Column G contains B:F in that order. <tbody> <colgroup><col...

Hi Guy's Any idea how to I turn my data output from this.... <colgroup><col><col><col><col span="3"></colgroup><tbody> 201309 201310 201311 201312 201401 A 13000 18266 15300 7250 25050 B 0 15568.9904 15000 16900 47040 C 0 0 0 8750 126082.4 </tbody> to this very quickly please...

Is there a quicker way to use vlookup with VBA. I have a lot of data that I would just use vlookup with, across multiple sheets. Hoping there's a way to speed things up. THANKS!

Hi all, The following formula is from one of the bosses spreadsheets. He is a heavy spreadsheet user but his formula skills stop around =a1+b1. He is a huge fan of copy/paste. So needless to say there is a lot of 'fixing' to be done, by yours truly. I am usually able to figure out what he did...

Hi Experts, Sorry for the specific use case and the inclusion of SAP but I have searched the Forum and other resources and I cannot seem to figure this one out. I am hoping someone out there is using SAP at there company and maybe has had the same use case. I am hoping to have a formula (not...

Hello, I have a worksheet with a long name "Timeline_123456789.24", and I want to know what sheet number it is. I don't want to have to type the whole name, since it's the only worksheet with this name. I was hoping to use "Temp*" to find it but it doesn't work. Is there a way to use a...

One of our accounting systems will export amounts with a suffix of " D" for debit balances (positive for non-accountants) and a " C" for Credit balances (negative). Obviously I can find and replace the " D" for my positive amounts, but I need to convert the ones with " C" to negatives. I can...

Hello, I am hoping that someone may be able to help me out as I am trying to find a method to copy information from a form that I have created that has a comments section on one worksheet to a USER NAME verified comments section on another worksheet. I hope that this is self explanatory and if...

hi, Does any know how to add the subject line into email body, rather than copy & paste into ? Hoping someone can 'rescue me' & thank you for your help. KR Trevor3007

I want a program a filter to automatically look for the amounts 28K, -28K, 32K, and -32K. I have to keep doing this but usually in different columns. I've had to do it 20x so far this morning. Is there some way to save this filter? What I'm doing right now is typing in "28," into the filter...