View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Flying_Dutcman
 
Posts: n/a
Default Numeric calculation

Thanks. Sent it through to your mail this morning.

"Bob Phillips" wrote:

Yeah in the post heading, but note my signature.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Flying_Dutcman" wrote in message
...
Don't know if I'm doing something wrong but it's still not pulling through
like it should. Do you have a mailing adress so that I can send you the
workbook? Please? I really appreciate the help.

"Bob Phillips" wrote:

Add a heading to the number column of say NUM

In H1 add NUM
H2, add 1

Goto dataFilterAdvanced Filter and check the copy to another location
button, add H1:H2 in the Criteria range, and add say M1 to the Copy To
range.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)