User defined function

[rmccain]

I have tried and tried and tried but to no avail.

How in the world do I turn the following into a user defined function"

To determine low time
=IF(MIN(IF($A$2:$A$69361=$A2,$C$2:$C$69361))=C2,B2,"")

To determine high time

=IF(MAX(IF($A$2:$A$69361=$A2,$C$2:$C$69361))=C2,B2,"")



Thankyou !!

[romperstomper]

May I ask why you want to? It will most likely be slower.

[rmccain]

Hello,

Because I have to scroll down tens of thousands of columns as well as apply it to several dozen sheets. Doing this by hand takes too much time.

Thankyou

[romperstomper]

What are you expecting to have to enter? Some of those references are relative so they would have to be input as arguments to the formula and unless the absolute ranges are exactly the same every time, you'd have to pass those as arguments too, so I don't think a UDF would really make it any easier. Also with several hundred thousand of them, your workbook will be very slow!

[PCI]

I don't see how UDF will help you, you will have to do exactly as you are doing with formula.
If the lay out of yhe sheets is the same a macro could help to spread the formula around

[PCI]

Else

try

Please Login or Register  to view this content.

[rmccain]

Hmmmmm,

After much thought I will take your suggestion. A macro would suit me much better.

Thankyou for your time !