Search results

hi Faseeh i am really not sure what you mean, i have not used them

Hi does anyone know if you can populate cells based on a selection from a list I want to set up a list using the SKU number then have excel pull the rest fo the information for example cell c2 has the list dropdown 102774 cell c3 2.5"African violet" cell c4 25 viol cell c5 $0.90...

Hi Faseeh thanks for the help. but i get an answer of 1 when i used the formula you sent

the spreadsheet is used to calculate stat holiday pay. i must look at the last 10 days worked prior to the stat day to determine the average hours worked to calculate the amount of stat holiday pay. This causes a problem if someone one is off within the last 10 days, so i have to then add the...

Hi Luke if the cell has a null value it is not counted, with that in mind i can only add 10 days values. it may happen that someone is off for two days in a 10 day period so the formula must look to the next two dates for a value greater the 0 and add them to the total

Hi I have a spreadsheet that contains hours worded by day for a calendar year I need to be able to calculate the total hours worked over a period of 10 days. How can I do so when the data is layed out as follows month jan 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23 and so on...