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: *

  • Users: Wicca
  • Order by date
  1. Wicca

    MAXIFS - transfers NUMBERS but wont transfer <1.6 from one tab to another

    Ahhhh Skip, you have such great foresight . . . [dazed] I have finally got it sorted, rather complicated (in my mind anyway) I moved the data to another tab and came up with this, it seems to work ok (Fingers Crossed) =IFERROR(IF(ISBLANK(INDEX('Whangamata...
  2. Wicca

    MAXIFS - transfers NUMBERS but wont transfer <1.6 from one tab to another

    Sorry guys, Now I am even more confused. I will try to explain the process from go to whoa 1. Field rep gets data and enters it into an app 2. App enters it into a 3rd party server 3. 3rd party server sends daily report out at about 4am 4. Report emailed directly to me, field reps (different...
  3. Wicca

    MAXIFS - transfers NUMBERS but wont transfer <1.6 from one tab to another

    This spreadsheet is emailed to several different users at about 4am daily (weekends included). It is also opened on random occasions by other users wanting information from it. To use a macro in this way would be extremely difficult to administer. Please remember, I am a user that has been...
  4. Wicca

    MAXIFS - transfers NUMBERS but wont transfer <1.6 from one tab to another

    The file is transmitted from the server at 4am to the users. Data is collated from various tabs to this tab for the users to use. As I noted above, macros are stripped from the file before it is generated so macros are not available. Obviously harder than I anticipated. Never mind, all is good...
  5. Wicca

    MAXIFS - transfers NUMBERS but wont transfer <1.6 from one tab to another

    Thanks Andy, I finally figured that part of it out, I stripped the < out and I realised it works fine, however I do need the < sign as its for legal compliance Can anyone help me with a way to get them across to the right tab? I have also tried index/match but the same result. I was thinking...
  6. Wicca

    MAXIFS - transfers NUMBERS but wont transfer <1.6 from one tab to another

    The problem is a "simple one" I am sure. I am using the MAXIFS formula but it is not transferring all the data. I have tried to put an explanation in the attached spreadsheet. While there are about 30 tabs to the spreadsheet I have left two open. The rest I dont think are relevant to the case...
  7. Wicca

    Hi everyone, Im working with a Loc

    Thanks Guys from a small Town Council in New Zealand. Worked perfectly I tried both methods and found that Unique() and MaxIfS() worked best for my application. I didn't even know they existed until I got your emails. Have a fantastic Day. With respect Wicca Believe in yourself, you are...
  8. Wicca

    Hi everyone, Im working with a Loc

    This is what I get from the network and need to get the largest number for each day With respect Wicca Believe in yourself, you are worth the investment.
  9. Wicca

    Formula needed for cell date tranfer

    A few more lines from the spreadsheet that may help with your thoughts . . Im totally baffled but then I am not great at this anyway 8700-3655 Bell Operating Bore Sites 4,819.54 32% 4,819.54 32% 15,000 15,000 8700-3660 Bell Operating Reserviors 482.24 40% 482.24 40% 1,200 1,200 8700-3665 Bell...
  10. Wicca

    Formula needed for cell date tranfer

    Hmmm I have a similar problem but not as easily solved I have the following text data in one cell and wish to break it into individual cells 8710-2000 Bbri Water Salaries 741.34 2% 741.34 2% 36,488 36,488 8710-2010 Bbri Water Travel/Accomm 164.27 21% 164.27 21% 800 800 I used left(CELL,9) and...
  11. Wicca

    Excel 2010 - How do I put data into a protected sheet?

    Thanks guys, I think I have the answer . . . you guys are awesome With respect Wicca Believe in yourself, you are worth the investment.
  12. Wicca

    Excel 2010 - How do I put data into a protected sheet?

    Account Description Total Margin Account Description Total 1/3000/01 SALES TRACTORS formula 2/3000/01 SALES TRACTORS...
  13. Wicca

    Excel 2010 - How do I put data into a protected sheet?

    Close but not quite. Yes I can insert a new row and that was good. I did put data into the cells that equated to the non-formula cells however, when I went to put data in the column that had data in, I was unable too as it said the cell was locked. With respect Wicca Believe in yourself...
  14. Wicca

    Excel 2010 - How do I put data into a protected sheet?

    I know this may sound like a silly question however, I have a manager that insists on overtyping formulae. I have a 600 line by 30 column speadsheet and every 4th column contains a link to a seperate worksheet. eg =Otorohanga!$C4 =Cambridge!$C20 =Rotorua!$C344 Every time he uses the...
  15. Wicca

    Excel expert opinions please

    Well, I have just used a VBA program in Excel (of course) and reduced a monthly data analysis task from 3 hours to less than 10 minutes . . . the majority of that time is actually inputting the data into the spreadsheet . . . a single click of the macro and its done and dusted, sorted, formated...
  16. Wicca

    Cells formatted ACCOUNTING don't work (simple subtraction calculaton)

    Thanks . . . now the accounts can go through with HAPPY accountants Cheers With respect Wicca Believe in yourself, you are worth the investment.
  17. Wicca

    Cells formatted ACCOUNTING don't work (simple subtraction calculaton)

    I have a series of cells that are all ACCOUNTING Formatted A B C D $43,622.43 $42,770.78 $851.65 $0.00 $20,089.53 $19,348.89 $740.64 $- $23,465.76 $23,087.19 $378.57 $- $29,706.87...
  18. Wicca

    Use a strong password, as my granddaughter does

    ROFLMSO that was so much fun to read . . . I use a 13 digit alphanumeric with special characters capitals and lowercase. I consider that to be secure enough for most instances . . . but it would not take ALL THAT long to crack if someone really wanted to . . . luckily my need for security is not...
  19. Wicca

    Delete Rows in excel when criteria met.

    Skip, Is there anyway I could put you in a carry all and bring you to NZ . . . you are awesome, thanks so much for this post Merry Part and the Brightest of Blessings With respect Wicca ----- IF you think you can Or If you think you can't Then You are probably right -Henry Ford
  20. Wicca

    How to calculate the hours difference between two hours of the day

    Ya know what Skip, sometimes I wonder if anyone ever reads the FAQ and good bits that people have left here. I see over and over this question and your reply. Thank you for your patience. Cheers Wicca

Part and Inventory Search

Back
Top