cases

Dear Gurus I am having a real problem with this. i have created a spreadsheet to log "projects" and various details about each one, e.g. country, lead staff member, date opened etc. I have roughly 40 columns that need to be populated. I have created a userform, called FrmNewCase, with all the...

Hi, New to the forum as I have a problem with a work sheet that has been bugging me all day. For example I want cell H5 to return the number of pallets it would require depending on the number of cases (I5) We can fit 126 cases onto a pallet so if I5 is between 1 and 126 then H4 should...

i think what i am trying to do is pretty simple but i cant figure it out. Basically i have two totals i want to add....so =A4+B4 Sometimes B4 will be blank but i still want to show the value of A4 with this formula. So in some cases =10+20 equals 30 in other cases =10+(blank value) equals 10

Hello, I apologise if I've done anything incorrect in the posting of this thread. I've lost all sense after trying to do this: I need to know that based on a footfall percentage (that will increase/ decrease with our forecasted estimates) and current cases in branches (based on what the...

I'm hoping someone out here can help me, or at least confirm that this is an issue. I have two queries based on the same table. Both use Excel.CurrentWorkbook(){[Name="Data"]}[Content] to call the source. The table contains records of interactions with clients, and there can be more than one...

I'm trying to figure out how to write this formula. The user can select either 'Cases' or 'Pounds' in the beginning. B2 is a drop down list 'Cases' or 'Pounds'. AD3 is a drop down list 'Yes' or 'No'. AF3 is a drop down list 'Yes' or 'No'. Pivot_CasesAV36 is the result if 'Cases' and 'Yes'...

Dear Experts, i have 2 sheets, in 1 sheet we have different town sale and in 2nd sheet how can i put these sale into their column. please help me in this. Sheet 1 <colgroup><col><col><col><col span="7"><col><col span="3"></colgroup><tbody> SAPCODE Code SKUName ID SKUID Opening Stock Receipt...

Hello, I have a table of data related to an invoice approval workflow where I would like to evaluate each invoice (request key) for the appropriate approver. Unfortunately, the workflow software doesn't store the final approver in a field, so we have to apply logic to the workflow data to...

Hi all, Hopefully someone can help me with this because it's driving me mad. I have two tables on separate sheets. The first holds a list of cases and who managed the case (and how long it was open, but that one is less relevant for now). The second has a list of staff that appear in the first...

Hi everyone, i have to run a weekly report with diffrent cases. Each case has an approval path and must be approved by 6 persons. I have to find all the cases which have John Doe in the approval path, either is he the first approver or the last, this does not matter. If John Doe is in the...

hello, how can i get the first 3 digits out of strings in cases the string starts with zero/s? in cases the string starts with zero/s, the function LEFT, ignores the zero/s... thanks

Hello, This is a continuation of a previous post, but I thought I should start a new thread since this is about SELECT CASE. (https://www.mrexcel.com/forum/excel-questions/1021927-excel-vba-use-consecutive-if-statements-use-if-elseif.html) I'm now using SELECT CASE code to do 2 things: 1)...

I'm often comparing Actual $ Results vs what was planned. The formula for this is ((Actual - Plan)/Plan). In some cases the Plan was zero, this giving an error. To fix that I've added an IFERROR(formula,0), which has fixed that problem. However in some cases the Plan isn't exactly zero but...

Hi all, Just a quick Excel question on sumproduct functions. Are there certain cases where you use "," verses "*" between criterias? Does it matter?

Problem: We searched a total number of cases (total cases searched) and found errors in x number of cases (cases found). The average errors in those number of cases found is "average mistakes per case". These cases were searched using 3 different softwares: Non-CAC, CAC, and Legacy Scrubber...

<tbody> Mar Apr May Jun Jul Aug Sept Oct Nov Dec Total Ops 5 10 15 20 25 30 35 40 45 50 275 Case/Month 4 8 12 16 20 24 28 32 36 40 220 Total Cases 20 80 180 320 500 720 980 1280 1620 2000 7700 </tbody> Above is the problem I am working on: We are assuming we can get 5 new operators per...

Hello, This is my first post, any help would be greatly appreciated. I create pull-sheets in excel everyday for 9,000+ orders. I have various different skus using (10) items. So at the bottom of the pull-sheet in order to help my warehouse dept, I have made formulas to tell them exactly...

OK I tried but I can't figure this one out. I have a list of IDs on Sheet1, cells A3:A7, then a list of dates associated with each of these IDs, cells C3:C7. At the top of Sheet 1, in cell B1, is a dropdown list of these IDs. I choose one, and that selection is populated into Sheet 2. =========...