Search results for query: *

I have the following IF statement. I'm simply trying to expand the second IF statement within the MIN function to say IF the range b16:b25 <> "ber" or "iw" I'm trying to say that if the date in A16:A25 and "ber" or "iw" is in the range B16:25, then skip to the next date in the range A16:A25...

I have the following array formula that will not work for some reason. {=SUM(IF(C4:C18="TRUE",IF(D4:D18="19:00",1,0)))} I have a checkbox over each cell in the range C4:C18. Each box is associated with the respected cell. So when a box is checked it returns TRUE, and of course, when its not...

Is there a way to only single click on a specific cell, but have the curser appear is if you had double clicked on it. I need this function for cells E6, E6, and G6 only. Thanks in advance. Regards, ep

Is there any type of code that could make a flashing curser appear when a specific cell is selected instead of the highlight around the cell? Thanks in advance. EP

I have three cells (E5, E6 and G6). The cells have border around them. I would like the border to be removed when the cells have data in them, and show the border when the cells do not have data in them. Thanks in advance. EP

I have several Callouts on a sheet explaining to the user what data to place in a specific cell. What I'd like to happen is that once the user enters the data into the specific cell for the callout to disappear. Thanks in Advance. EP

I have a simple excel calendar. Each cell for the month contains a Text box with the date in it. I also have a checkbox next to each date. What I would like to do is,if an employee checks a particular date, take the total number of checks in a specific two week period and return them to a...

I have a range of Data: F8:CT8 I need to count every 3rd column in this range starting with F8. I just need to count if there is data in the cell excluding zeros. In other words F8 F9 F10 F11 F12 F13 12 17 I need to know if there is data in f8 and f11 and so forthe...

I'm looking for an IF statement that basically says the following: IF R6 = a weekend (Friday,Saturday,Sunday) then K36 = Data!CY8*(1.23) IF R6 = a weekday (Monday - Thursday) then K36 = Data!CY*(1.13) I'm not sure how to have it determing the weekends vs weekdays. Thanks in advance. EP

Okay, so I've got the first formula below working, but I need to expand on it. Should I write a custom function in VBA?How? Or can I somehow combine all of these functions into one? So what I'm looking at is: I need it to perform the same OFFSET function, except with a change to the range. I...

I would like to know if I can add another IF statement to the following formula. For example IF cell H9 = "Day" then perform the function. Thanks. EP =IF(Date=0,"",OFFSET(Data!$E$5,ROW(A1)+100,MATCH(G 8,Data!$F$3:$CT$3,0)))

I have the formula below, which takes the date from a cell(G8) and finds the corresponding data in another worksheet(Data!). This formula is working. But for some reason I can't get a second formula to look up the data one cell to the right...

I'm new to VBA, and I've managed to create a button in an excel spreadsheet. The button, when clicked, takes a range of data in one sheet, and copies the values to a range in another sheet. My problem is that if the original cells do not contain data, and I press the button, it will overwrite...