picking

Hello everyone, I am currently trying to create a detailed overview of transactions executed by a range of different users in the hopes of creating a easy to understand overview of performance. Which will include the points listed below. In this performance overview I want to include several...

Hi: Can someone please help me with this? I have the monthly sales organized in this way: Jan-19 (Column A), Feb-19 (Column B), Mar-19 (Column C), ...., Dec-19(Column L) I would like to calculate the YTD (year to date) sales based on a picking list (I now how to do the picking list). For...

Hi I have a spreadsheet, with a lot more data than below spanning quite a few years. I want to add a summary page to show the totals by individual by year. As it's a moving piece i didn't want to put a YTD total on and use a sumif, i was wondering if there is a way of looking across a row and...

I am trying to find the coresponding code that goes along with the clock in and clock out times. I have tried everything and cannot find a solution. Please help. For example< I need the times between 5:45 Am and 5:59 Am to correspond with code 2. The formula I have used is...

How do I get the right function to pick up 0 as the second decimal place? I'm trying to get zero from =RIGHT(A1) where A1 is 2,366,125.60 but excel is picking up the 6 since it drops the last zero. Thanks

Hi Guys, Just found this forum so hoping you can help! I have a pivot table with the following nested IF statement in the calculated field section but it only appears to be picking up the >20% part and the *8% bit at the end...any ideas why? Thanks <tbody> Bonus =IF('% Margin'<0,0,IF('%...

Hi guys, I seem to be having an issue getting excel to calculate properly. I have a table showing: Picker name(Col B) the time spent picking (Col C), units picked per person (Col D) and want to work out a pick rate(Col F). <colgroup><col width="160" style="width: 120pt; mso-width-source...

I am dragging some data from various sheets and presenting it on a single line =IFERROR(VLOOKUP(H5&"|"&B5&"|"&D5,comments!$A:$B,2,FALSE)&" ("&TEXT(((VLOOKUP(H5&"|"&B5&"|"&D5,comments!$A:$D,4,FALSE))),"dd/mm/yyyy")&")",Z5)&IF(AE5<>""," //-// Picking info: "&TEXT(AE5,"dd/mm/yy")&" "&AF5,"") If...

Evening. I have searched the forum but could not find the answer. How do I prevent a formula when searching for a 1 picking up say 12 for example?

Hi guys, i want to extract hyperlink text from the friendly names that i have when i use range.hyperlinks(1).address property it only gives my first 40 characters of the hyperlink I am actually trying to extract last 7 characters from the hyperlink , but since it is not reading more than 40...

Hi, I have a database of which is a userform and i select my info to appear from making a selection from within a drop down box. Currently when the form opens its fields are blank & i am having to select from drop down box so the fields now have data & then i can use the up/down arrows on...

Hi, Is it possible to to use 2 x array formulas in the same function. I.e. {=sum(countifs(range,{"text","text"},range,{"text","text"}))} I'm trying but it's only picking up the first text from the second array. Any ideas ?

Hi, I have the code below which works fine. I have now added another Image box called Image2 and asking for some advice please in reference to also load a second photo into it. Currently the working code below only loads a photo into Image1. I am looking for advice to edit the code so at the...

There are 3 balls in a bag, one red, two blue. Therefore, there is a 33.33% (Cell A1) chance of picking the red ball, and a 66.66% (Cell A2) of picking a blue ball. Would there be a formula to calculate the probability in a 'Best of X' race? So for instance, what would be the probability of...

Im trying to save an Excel file (2010) as a pdf. It contains 5 tabs however it is only picking up 4 of them i have googled the solution and 1 suggestion was that the print quality needs to be the same on all the tabs, which it is but im still getting the error. any other suggestions? Thanks

I've had this spread I've used for literally years to pull in PGA golf stats- originally created pre-2003 I think. I've not changed it much, other than save it into new formats along the way, because...it works, so why. It was working fine as recently as last Sunday, but for this week's...

Hi experts, I am working on a file where some data is picked from one sheet to other by using vlookup function. Hyperlinks are not being picked automatically in other sheet. In Sheet 2 A1 consists of drop down list from Sheet 1 B5:B6. In B3 below formula is used...

Dear Smaritans, I am trying to create a spreadsheet for a picking operation. It has three tabs (sheets). The first one got the Picking request (provided), the 2nd got the inventory (provided), the third one is the picking sheet which is to be created as per the other two sheets. Sheet 1...