Posts by Sicarii


Re: Convert Difference Of Minutes Calced Into 6 Minute Increments
Umm, 08:00 AM  12:30 PM equals 4.5 hours, not 4.3 and 4 hours and 24 minutes is not 4.24, it's 4.4; there isn't 100 minutes in an hour.
I've also already provided you the formula

Re: Count Cells Depending On Weeknum Criteria
Provide a sample file displaying desired results...

Re: Convert Difference Of Minutes Calced Into 6 Minute Increments
What is it that you want? I don't follow...
8:00 AM
8:06 AM
======
=((A2A1)*1440)/60...will result in 0.10

Re: Return Occurrence Number Of Lookup
Since your audience are complete noobs, maybe you should look into just writing up a "simpler" interface that automates the pivot table...

Re: Insert Columns Based On Inputs
It almost seems like you're trying to make this harder than what it has to be...but, why not design two seperate templates and based upon the users opening input decide which to show and which to hide?

Re: VBA Code To Password Protect Workbook
I believe it was a sharp and often satirical or ironic utterance designed to cut or give pain and when I looked that up in Help all it said was sarcasm.
edit: bah, I guess Dave beat me to it

Re: Enter Date Without Dashes?
Care to post your solution for future searches?

Re: Enter Date Without Dashes?
Custom Format: 00\/00\/0000
This will allow you to enter "05142006"; the actual cell will lose the preceeding zero, but it will display as "05/14/2006"
edit: your latest post says you want to enter "032404" so that would need a custom format of: 00\/00\/00

Re: Return Occurrence Number
A sample file might help get the correct solution quicker...


Re: Conditional If Function
Have you looked into Solver at all? menu: Tools\Solver...

Re: Find & Return Weekly High Value
In the formulas, adjust the range of columns A,C, & D in the respective formulas to look at, for example...$A$2:$A$27 to $A$2:$A$1276...after placing these in row3, you can simply drag them down or copy/paste all the way down.

Re: Find & Return Weekly High Value
They work perfectly for me...You need the Analysis Toolpak addin installed.

Re: Sum Cell Across All Files In A Folder
Have you utilized the search functionality of the site or even review your possible answers? See the link below to loop through files.

Re: Cell Sort With Index & Match Function
Hmmm, why not just goto menu: Data\Filter\ and turn on AUtoFilter?

Re: Find Weekly High Value And Copy
Well, I learned something new today (chaching), you can't use WEEKNUM() in an array so at first I was going with a helper column, but then I gleaned this for your max value:
=MAX((INT(($A$2:$A$27DATE(YEAR($A$2:$A$27),1,1)WEEKDAY($A$2:$A$27))/7)+2=WEEKNUM($J3))*($C$2:$C$27))
This is an array formula, use <CTRL>+<SHIFT>+<ENTER> and not just <ENTER>
edit: and here is the min:
=MIN(IF(((INT(($A$2:$A$27DATE(YEAR($A$2:$A$27),1,1)WEEKDAY($A$2:$A$27))/7)+2=WEEKNUM($J3))),($D$2:$D$27),""))

Re: Find Weekly High Value And Copy
no attachment

Re: Lookup Cells Around An Address
Assuming you're essentially only wanting to have a 4 column range returned...
Putting the data in A1:E5...
Insert this in G1 and drag down:
=IF(ISNUMBER(A1),A1,B1)Insert this in H1 and drag down/across:
=IF(AND(ISNUMBER(B1),G1<>B1),B1,C1) 
Re: Copy Data From Another Sheet If Adjacent Cell Meet Criteria
Why reinvent the wheel? Just put this formula in B2 of sheet1...adjust your lookup array range
=VLOOKUP(1,Sheet2!B3:C5,2,FALSE)