• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    How to convert number to a bar code within excel

    Hi , I am trying to set up excel to covert my numbers into a code 39 bar code. I already have the codes but they are showing in excel as a number. Any idea how to convert back Column E is the number. look forward to hearing from you. Arthur
  2. S

    Updating weekly rota

    Khalid - you rock. In fact I now understand the formulas a lot better thanks for your advice
  3. S

    Updating weekly rota

    Hi , I am looking for help with the following. =vlookup(MastersheetF4,VDQ Weds D3:D60 - if true returning = VDQ Weds column C3 ) Basically - If 914 is on VDQ weds D3:D60 return VDQ weds Column C3 Any advice would be amazing
  4. S

    Vlookup using 1 value & 1 text data if both true returning the value data

    any help ladies and gent's proper struggling here
  5. S

    Vlookup using 1 value & 1 text data if both true returning the value data

    Hi Narayan , Rule 1 - look =VLOOKUP(MASTER!D4,’VDQ Monday’!A2:A166,1,0) this returns payroll number 914 Rule 2 - =VLOOKUP(C3,’VDQ Monday’!D2:D166,1,0) this returns Name "RKD Sprout Peeler" RULE 3 - If rule 1 is true (payroll 914) and rule 2 is true ( Name "RKD Sprout Peeler") please return the...
  6. S

    Vlookup using 1 value & 1 text data if both true returning the value data

    Hi Everyone , please help with the formula. New to this game =VLOOKUP(MASTER!D4,’VDQ Monday’!A2:A166,1,0) (914) =VLOOKUP(C3,’VDQ Monday’!D2:D166,1,0) (RKD Sprout Peeler) I need to combine the two arguments Help
  7. S

    Vlookup

    Hi Narayank , 1 - VDQ Saturday to VDQ Friday will have the same fields always. We will be exporting the data on these sheets daily. 2 - The data imported onto VDQ sheets need to picked up on the Saturday to Friday (colour) tabs 3 - Using the MASTER(payroll numbers) as first unique identifier 4...
  8. S

    Vlookup

    Hi everyone (awesome site), I am looking for some assistance on the excel sheet attached? Example we are trying to be able to set the colour tabs (Monday etc) to accept a file dropped into VDQ Monday and this will populate the Monday(coloured tab) based on the following; If "master sheet D4"...
  9. S

    Hi everyone (awesome site)

    Hi everyone (awesome site)
  10. S

    Counting data ( 80% to 90%) the numbers times they appear with a range of cells

    Hi everyone , I am looking for some advice on the following: Performance management is a tool we have to use and I have set an excel spread sheet using conditional formatting (changes colour). But I now need to know the number times between 80% and 90%. I have used countif to find the number...
  11. S

    Counting name data across different excel sheets and returing a total

    Hi Guys & Gals , Struggling a bit to formulate a string to pick up the following information ; Summary ( Final destination) NAMECONTRACTIDDRYSDALE ASSIGNGVAP ASSIGNHAGGERSTONSETON Abida, Mustapha0 Sheet 2 NAMEcontract Abida, Mustapha1 Sheet 3 NAMEID Abida, Mustapha 1 Problem I have is the...
  12. S

    how to minus a zero when using average

    Hi, I am hoping someone could help with the following question. How to not pick up a zero when using average Thanks
  13. S

    Minimum amount to be shown from multiple data sheets

    Awesome - thank you for this. With this formula combined with " Control + Shift + Enter" this works prefect. Star :)
  14. S

    Minimum amount to be shown from multiple data sheets

    Hi , help. I looking for help with the following problem. Attached is copy of a document we use to record output in production area. Question. Howe do I get the following to show the minimum amount? =SUMIF('Line data'!C5:C133,'Line Data Weekly'!A6,'Line data'!I5:I133) this shows the total...
  15. S

    Rolling 12 week average pay - Need help please

    Hi I am new to this group but have had help before and now I asking again. The issue I have is as follows - Rolling average of pay - Data Range - B4 - B16 on going up to B56 - people weekly salary. A2 - A567 - Individuals Names. I need formula which shows 12 week average rolling each week...
Back
Top