Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. karron

    Advanced Excel Test

    I wonder if anyone could help me, I need to put an Excel test together to accompany an interview. Can anyone point me in the right direction? cheers
  2. karron

    Relative vs. absolute references

    thankyou but i need the formular to remain within the cells and also i need my references to remain the same.
  3. karron

    Relative vs. absolute references

    Does anyone know if it is possible to highlight a section of data in a spreadsheet and make every number absolute, without having to click on number and press F4?
  4. karron

    Could you please sugest a way I cou

    no,I don't think you understand, i need the cell to work out whether or not that months data is in, if it is enter the data in the cell, if it is not take all the months from before it and average actual performance against the target and return a proposed figure.
  5. karron

    Could you please sugest a way I cou

    Could you please sugest a way I could do the following: I have the following formula =MarketsPhased!C4*AVERAGE ($C$2/MarketsPhased!$C$2,$C$3/MarketsPhased!$C$3) basically trying to predict the performance for this month based on an average of previous two months performance. I will be...
  6. karron

    Excel nested issue

    thankyou very much that is perfect!
  7. karron

    Excel nested issue

    If i use the AND function with the if is that not for two criteria for example if it is <>then enter this, how do i use it for for what i am doing when i want a unique number depending on each individual criteria?
  8. karron

    Excel nested issue

    On a monthly basis a sheet of data is inserted into a different worksheet, each worksheet named after the month. What I want to do is check to see if the data is in these 12 pre-named worksheets and place a value in the cell, like the following...

Part and Inventory Search

Back
Top