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 Chriss Miller 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. kendue

    Thoughts on Excel for HR Vacation Time Tracking

    Skip, I'm sure you could design a very sophisticated system to handle the information in question, but in kjv's real world situation, it seems that a K.I.S.S. approach might be more advantageous, at least for the time being. If the person working with the system either cannot understand how to...
  2. kendue

    Thoughts on Excel for HR Vacation Time Tracking

    kjv, When I saw that post you referenced, it reminded me of the vacation accrual sheet I had already designed several years back. If you decided on that type layout, I figured it would give you a good starting point to try out some sample data rather than having to start completely from scratch.
  3. kendue

    Thoughts on Excel for HR Vacation Time Tracking

    I also have a version of a vacation accrual for your perusal. It is set up for a $$ basis of vacation cost, but could be altered to use time in hours instead. additional columns can be added for department breakdown, etc. Maybe, if you get enough input, the correct answer will make itself...
  4. kendue

    Format numbers within a string with colour

    Make the entire column showing percentages green to start with, and use conditional formula to change percentages less than 96.00 = "red".
  5. kendue

    Excel 2010 Simple Profit Formula - Please Read

    zelgar, your formula does not consider the occasional sale at less than cost (a loss). WillieMaykit's formula, and my suggested formula, both allow for such a possibility. Why is everyone trying to make this so difficult??? I'm curious as to why we haven't heard anything from ladyck3 if any of...
  6. kendue

    Excel 2010 Simple Profit Formula - Please Read

    combo, while it should be obvious with a blank cell in the Profit/Loss column that the item has not yet been sold, you would be able to show that in the Profit/Loss column without adding another column by amending the formula to =if(I19>0,I19-E19,"not sold"). This would not affect the summation...
  7. kendue

    Excel 2010 Simple Profit Formula - Please Read

    mintjulep, there IS a need for a conditional test... to test whether or not the item has as yet been sold. An alternate to WillieMaykit's formula (which looks fine) would be =if(I19>0,I19-E19,""). The profit/loss column will show only results for items that are already sold, and can be summed...
  8. kendue

    Conditional Formatting

    Skip, I responded before I saw your last correction. NOW it works as I needed. Thanks for your help on this. I want to give you a star, but I don't see where to do so... has that been eliminated?[thumbsup2]
  9. kendue

    Conditional Formatting

    Hi again Skip, This formula works if the only word in the description is "TOTAL", but not where there are ADDITIONAL words in the description. I need a "contains" function within the formula to make the formula work. Thanks for your help. Ken
  10. kendue

    Conditional Formatting

    Hi Skip, I believe I need to write a formula within the Conditional Format rule that identifies the description cell and then applies the correct format to a different cell next to it. I don't know the correct syntax for writing that formula, but in pseudo syntax, I believe it should be...
  11. kendue

    Conditional Formatting

    I am using Excel 2007 and I want to use conditional formatting to make a number in various cells in column M bold where a text description next to it in column L has the word "TOTAL" within the line of text. I am able to make the text in column L bold for descriptions that contain the word...
  12. kendue

    How to convert PDF files to Excel

    Your bank may have an online download process in .csv format that directly loads into Excel. Have you explored that possibility? It would certainly save the hassle of converting from pdf.
  13. kendue

    Relating Data in a MAil Merge

    Since your information is already in Access, why not bypass Word altogether and build an Access report in letter format that will allow you to insert your fields as needed. The multiple tracts issue would be easily handled within the Detail section of the report, and the Header section would...
  14. kendue

    Dcount with Different criteria

    Couldn't you put your control for the summation in the detail, then sum the control in a group footer grouped on "div", and set the detail as not visible or "cancel print"? That way only your group totals would print.
  15. kendue

    How many days between dates

    Format your formula cell as a number and your answer will be accurate using the =H2-Today() formula. Then Conditionally format that same cell as color red for value less than zero.
  16. kendue

    How to vlookup with wild card and return multiple values

    Have you tried applying an AutoFilter to the column containg your bracketed information? Click on the "Custom" selection and type "[ce" or "[K", etc. for your criteria to search for. This will list all information that meets your criteria.
  17. kendue

    Excel sumproduct

    See if this solves your problem. If column A contains the numbers you wish to sum beginning with row 2, type this formula in column B starting with cell B2: =if(A2>0,B1+A2,0) Copy this formula down as far as you have rows. You will have a running summation for each group. If you don't want...
  18. kendue

    Need syntax help in Macro to identify last row of Excel data

    Skip, That is precisely what I needed. Thank you so much for your help!
  19. kendue

    Need syntax help in Macro to identify last row of Excel data

    Sub copyformula() ' ' copyformula Macro ' Macro recorded 6/3/2011 ' ' ActiveCell.FormulaR1C1 = "=IF(RC[-20]<>R[-1]C[-20],RC[-1],0)" Selection.AutoFill Destination:=Range("W2:W200") Range("W2:W200").Select End Sub
  20. kendue

    Need syntax help in Macro to identify last row of Excel data

    As I explained in my follow-up message, I want to copy the formula placed in the cell "W2" down that column for as many rows as there are lines of data which will vary from day to day. If done manually, this can be accomplished by simply double-clicking on cell "W2"'s handle. I don't see what...

Part and Inventory Search

Back
Top