Search results

http://chandoo.org/wp/category/power-pivot/ Chandoo.org is a great resource where i first heard about powerpivot...but have not had the chance to play with it (work restrictions)

ooppps..... i realized this is a general access thread......... thought it was just a general threadh with no tie to a particular app. access may or may not be used at all... sorry, this can be moved if best placed in the word forum (but at the same we may not use word either... lol)

it may be word... but doesnt 'have to be'. just the first option that was brought up. i need responses to be as detailed as possible

ok, so i'll try to keep this short but detailed enough. lets say we have 100 documents. 30 of these documents contain the same exact set of instructions that i want to update/change. what options would i have that would allow for this 'mass update' so that i can change that specific...

ms2007+ uses a different 'format' for the files than what was previously used. So if you try to open a 2007 doc on a pc that does not have the 2007 suite or the previously mentioned add-in installed, the pc will not recognize the 07 doc file at all. it will see that theres a file, but it will...

H14 will be Blank because that is what your formula is set to do. IF(G14<(D14-C14): If G14(3:30) is less than D14-C14 (which is also 3:30)... this condition would be false as it is equal to...therefore, it goes to the Value if False Argument which is ""...meaning blank. as for Col I: that...

im not sure how many ranges you would need to reference, but if theres only a few you could just copy them to the sheet where you want this countif. ...or preform the count if on each sheet, then use the SUM Funciton to add the totals across sheets.

whats the cell format set as?

ahh i see youre date and time are in two separate columns..... let me see about that i think i got it!! Complete date is E15 complete time is F15 Contact Date is b15 contact time is c15 =(((E15+F15)-(B15+C15))*24)*60 let me know if that doesnt work

yes... it should i think it is important that the start/end time cells are formatted here are two examples i played with to check. mm/dd/yyyy hh:mm:ss stat time--------------end time------------length in mins 2/14/13 1:00 AM ------2/14/2013 1:30 -----30 2/14/13 1:00 PM ------2/15/13 2:00...

assuming your start time is in a2 and your end time is in b2 =((B2-A2)*24)*60 ...i think

$B$2 will cause the formula to only and always look at that specified cell..... no matter where you move the formula (filling down to rows below)........... thats going to cause a bit of an issue wouldnt it?

IF(AND($F2>=MIN($C$2:$C$10);$F2<=MAX($D$2:$D$10);$B$2=$G$1);$A$2;"Free") try that? added a ")" and removed a space from your previous formula... any luck with the pic?

shouldnt the formula have a comma (,) between the 2 condtions you have inside the AND function? ..instead of the (;)?? and everywhere else? lol i believe commas have to be used to separate the different arguments/parts of a function. also, it appears that you have too many arguments...

you want the % cells on the summary sheet to be shaded? why not just do conditional formatting?

I believe you can only format the font. if you dont have that many labels, you could instert your own text boxes to use as the labels; that would give you the control you're looking for...but could take a minute.

it wont be a straight forward formula.... does the above text sample show in the same column or multiple like below? ColA | ColB | Call#1 | arrived at site| Call#1 | turned on equ...

I havent tried this before... but when you Insert Object--From File--(select the spreadsheet file that has your scoring)-- into a slide in powerpoint. if you double click on the object it will open the excel interface and have all excel options (formula bar and what not) while still being...

if you want it to simply be formatted a diff color for each code, then yes..... if you're wanting to to beformatted if its simply been changed, ....never tried that. you may want to look into Track Changes on the Review Tab.

hmmm... very interesting idea!! very applicable too! im sure one of the coding guru's here will be able to assist. also, chandoo.org is a super helpful website (where you can post/ask a question)...many excel ninjas there!!! lol