picking

  1. L

    How to create a detailed performance overview (Maybe a graph/chart)

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

    Formula for YTD (year to date)

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

    Using Titles of rows to sum date in columns.....

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

    Excel Problem

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

    Right function with second decimal place is 0

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

    Nested If in pivot table

    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('%...
  7. S

    HELP! Adding 24 has ruined my formula....

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

    Partial colour text with Excel Formula?

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

    Single Digit Number

    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?
  10. M

    hyperlink address

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

    Automatically have first drop down item selected

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

    Array Formulas

    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 ?
  13. I

    Text box change to load two pictures

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

    Probability Formula?

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

    PDF Not picking up all Excel Tabs

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

    Web query issue

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

    How to copy hyperlink with formula

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

    Excel, VBA - creation of picking form

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top