Search:

Type: Posts; User: bill351; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    8
    Views
    189

    Re: Index and Match formula not functioning

    **** it I cant believe I was that stupid to swap those 2 around GRRRRR swapped them and it all works just as it should

    Really Sorry Aladin for wasting your time Thank you for all your help
  2. Replies
    8
    Views
    189

    Re: Index and Match formula not functioning

    Sorry Aladin Didn't think Data!G2:G13 is the cost centers I put in countif for Data!F2:F13 which is the name in F3
    Data!F2:F13 has come back as a count of 1
  3. Replies
    8
    Views
    189

    Re: Index and Match formula not functioning

    That come back as zero?? which is Odd as I am looking at the unit name
  4. Replies
    8
    Views
    189

    Re: Index and Match formula not functioning

    Sorry Aladin Akyurek the straight formula and the array formula didn't work still have the #N/A
  5. Replies
    8
    Views
    189

    Index and Match formula not functioning

    Hey Guys and Girls

    I am puzzled, I have a spreadsheet with formulas for different section on the sheet 2 work perfectly the 3rd not so good all formulas are similar its just the Index data and...
  6. Replies
    9
    Views
    463

    Re: IF and LOOKLEFT and LOOKRIGHT functions

    Thank you vmjan02 that looks like it will work and please excuse the clumsiness of how I tried to explain what I needed to do
  7. Replies
    9
    Views
    463

    IF and LOOKLEFT and LOOKRIGHT functions

    Hey Guys n Girls I am trying to automate a data spreadsheet with the above functions.

    What I have is spreadsheet to record Higher Duties and Column A is Payroll Number Column B is the staff name...
  8. Replies
    1
    Views
    176

    Re: Calculating the hours between to times

    Hi Guys n Girls
    Thank you to everyone I have found the solution to my problem and it was just a formatting issue when I formatted the summery cells to [h]:mm it all tallied correctly

    Thanks...
  9. Replies
    1
    Views
    176

    Calculating the hours between to times

    Hi Guys n Girls

    I am making and Auto Calculating Roster that everything works great EXCEPT totaling the hours worked.
    What I have is a start and finish time and that returns the hours for that...
  10. Replies
    3
    Views
    235

    Re: Percentage comparison between 2 cells

    Hi JumpingCrab that is perfect thank you very much for this solution
    Greatly appreciated

    Bill from OZ
  11. Replies
    3
    Views
    235

    Percentage comparison between 2 cells

    Hi Guys n Girls I am tracking Sick and Overtime in a financial year spreadsheet which is working well in showing the top hours for different staff. I would like if possible to show a percentage...
  12. Replies
    4
    Views
    355

    Re: DATA SPREADSHEET WITH Sumif array formula

    The data in F84:BG84 can be a combination of any 2 digit number IE "OT 24". Is what you are indicating to that the ,2 should be a 3? because the highest number could be 100 or 10.5 the common factor...
  13. Replies
    4
    Views
    355

    DATA SPREADSHEET WITH Sumif array formula

    Hi Guys n Girls
    I have a spreadsheet that I am using to analyse Leave patterns and Overtime which is working pretty good with the formula...
  14. Thread: Countif

    by bill351
    Replies
    4
    Views
    310

    Re: Countif

    thankyou I will give that a try tomorrow when I get to work
  15. Thread: Countif

    by bill351
    Replies
    4
    Views
    310

    Re: Countif

    Hi BrianJN1

    The significance of the "*" is because the input to the cells for the shift times are varied so a specific Countif cant be done hence the use of the wildcard. So with that formula I...
  16. Thread: Countif

    by bill351
    Replies
    4
    Views
    310

    Countif

    Hi Guys

    I am trying to equate the working hours in a roster to check for budget anomalies and in a row for the fortnight I have the days worked (0730-1930) and the rostered days off (R/O) now the...
  17. Replies
    5
    Views
    248

    Re: VBA for Auto Date/Time

    Thanks Fishboy I will give that a go when I get back to work on Mon
  18. Re: calculating the number of days between two dates

    May sound too simple but enter in L =K2-J2 and copy down.
  19. Replies
    5
    Views
    248

    Re: VBA for Auto Date/Time

    Hey mrmmickle1
    This what I am trying to make work


    <tbody>
    1
    Hrs to date
    Date
    Auto
    Time Called
  20. Replies
    5
    Views
    248

    VBA for Auto Date/Time

    Hey Guys n Girls
    I was given a VBA solution by Joe4 (thanks heaps Joe) and it does just what it is suppose to do very well. So when I enter a name in column A I get the current date and time of...
  21. Replies
    2
    Views
    210

    Re: Auto Date and Time

    Hi Joe4
    Thankyou for that I will give that a go when I return to work Thursday

    Cheers
    Bill
  22. Replies
    2
    Views
    210

    Auto Date and Time

    <colgroup><col><col><col span="2"><col span="2"><col><col><col><col></colgroup><tbody>
    Hi Guys n Girls
    I have a data collection sheet on phone calls made to different staff and in that I have...
  23. Replies
    2
    Views
    328

    Re: Conditional Formatting for expired dates

    Thanks MarcelBeug

    That works great the only thing I added was no format if blank and it all works just the way I want
  24. Replies
    2
    Views
    328

    Conditional Formatting for expired dates

    I have a range of dates of when documents are sent in to the managers column H and what needs to be achieved is any date that is past 7days needs to be highlighted red so as to prompt an action....
  25. Replies
    3
    Views
    137

    Re: Conditional Formatting for date ranges

    Hi SRMPURCHASE

    Thanks for that but it still isn't working for me I am beginning to think its my Excel After putting in the formulas in it is still doing the same, the -7 days works just fine...
Results 1 to 25 of 83
Page 1 of 4 1 2 3 4