Search results

Ok Prasaddn -- now that you reminded me of Pivot tables, can you remind me how to change which data is used for the chart. I tried to right click the chart like I do with charts I built, but that didn't work. I update the charts weekly so this could be very helpful:) LCD

thank you, I totally forgot about pivot tables but it is good to know the correct syntax -- that is what always kills me

Hi all-- I have a spreadsheet that calculates down time on a machine (G#-F#). The time is in H# and the reason is in for the down time is in I#. I tried =SUM(IF(I5:I60="Heaters",(H5:H60),"")) to figure out the total time the machine was down due to the heaters, but it didn't work. I would...

Luke you are SOOO awesome. Where and how long did it take you to learn code. I really would like to learn it but don't know how to start Thanks again LCD

the time stamp which is the format of the inputed data, is really unreliable, some times it works, some times no. Any thoughts? LCD

Hi all-- Thank you for your help. It works almost. I figured out the typo of 6 and 8. But if you could please look at my worksheet there is still a bug I can't find. When I typed it exactly like Fred (thanks a ton) did with the typo corrected, I got column c but all the most entries were...

you guys are awesome!!!! I can't wait to get this into the spreadsheet. Thanks for showing me another way to use MOD

I have the date, I am trying to figure out which team worked on a certain date. But yes it could be date + 14. So how do I tell Excel to look at a given date and see if it is Oct 24 + a multiple of 14?

Thankyou Luke for the shortened formula:) As for the shift work, Team A has a morning crew that comes in at 5 am and and evening crew that comes in at 5 pm on days they work. Team B the same thing. This is figured out with the Lookup(mod......) formula What I would like to do is figure out...

Hi all-- We are on a 24/7 schedule where I work with 4 teams A-1st, A-2nd, B-1st, B-2nd. We have a spreadsheet with a timestamp (mm/dd/yy hh:mm:ss). Currently I use this: =IF(MOD($A6,1)<VALUE("5:00"),2,IF(MOD($A6,1)<VALUE("17:00"),1,IF(MOD($A6,1)<VALUE("24:00"),2,""))) which...

Hi Fred-- Well that's a start; as it stands right now we have a vlookup finding all the A's in the column and then have Excel count how many there are then we manually divide that number by 5 (Mon - Fri) and go out to the warehouse to count those A items. Can we somehow tie the Vlookup...

Ok, let me see if I can decribe the scenario a bit better. We have four different categories of inventory (A,B,C,D)(though there is NOT a set number of any category-- each category gets refreshed at the beginning of the month). The categories are based on usage. What we want to do is count...

Hi all-- I am working on a large MONTHLY inventory sheet with 400+ rows. In column AM, a letter is displayed based on amounts found elsewhere in the workbook. "A" for over 10,000, "B" for 5,000 to 10,000, "C" for under 5,000 and "D" for under 100. This is a dynamic letter which changes month...

sweet I will try it and get back to you:) Thanks again LCD

Hi Luke-- I believe the answer is yes to both questions, though the item may or may not always be in the same row.

Thanks Luke / Fred, sorry I did not explain myself. Let me try this way, if cell AB 21 has a value of 1QASW2, then we need to go to the other speadsheet (which will be open already), find "1QASW2" in lets say cell B2, then copy cells C2 - I2 back onto the original spreadsheet in cells AC 21 -...

Hi all-- My colleague thinks I am an Excel genius (he just doesn't know I am a member of Chandoo.org :) ) He asked me for help on this scenario. He has a large spreadsheet with lots of inventory data. When the actual count is outside a certain range compared to the projected count (plus or...

You are AWESOME, thank you thank you thank you:)

Hi all-- I have a spreadsheet that makes a time stamp when a cell is filled. The time stamp is in the form MM/DD/YY HH:mm (with 24 hour time). In the next column I need to be able to say if the time is between 07:30 - 15:30 then a 1 is displayed (for 1st shift), if between 15:31 -- 23:30 then...

Thanks Luke - Although the macro just made the cursor drop down on row; I figured out what I need to do. I need to use the tab button more and stop using the arrow keys. Make yours a terrific day. LCD

Hi all-- Can anyone give me some advise on this. When I hit the Enter button, the cursor goes to the next row (that is good) but it doesn't go to the same column (that is bad); I would like it to go to the first column everytime without having to hit Home. Any thoughts:) ? Thanks LCD

Thanks for the help Luke, but when I put it in the below code, I get the debugger window and it highlights that line of text. Did I put it in the wrong place? LCD Sub rotary() ' ' rotary Macro ' ' Range("A4:J156").Select ActiveWindow.SmallScroll Down:=-165 Range("A2:J338").Select...

Thanks Luke-- When I pasted your code below, I got an error. Please let me know your thoughts on fixing it. Range("A4:J156").Select ActiveWindow.SmallScroll Down:=-165 Range("A2:J338").Select ActiveWindow.SmallScroll Down:=-330 ActiveWorkbook.Worksheets("Rotary").Sort.SortFields.Clear...

Hi all-- I built a macro to sort out a section of my spreadsheet (thanks for the help), what I could not figure out is how to have the macro put the cursor in the first blank cell in the first row. What do I have to do to go to the end of the line automatically:)? LCD

thanks that did it:) LCD