Find Jobs
Hire Freelancers

Do some Excel Work

$10 AUD

Completed
Posted over 7 years ago

$10 AUD

Paid on delivery
I need to add SUBTOTAL into this formula so I can have it run when I filter the table: =MAX(FREQUENCY(IF(Table135[Result 1]="ITM",ROW(Table135[Result 1])),IF(Table135[Result 1]<>"ITM",ROW(Table135[Result 1])))) It searches a column that contains ITM or OUT and looks for the highest number of consecutive occurrence of ITM. However in its current form It does not reflect when you apply filter to the table which is not ideal. But I just cannot figure our where to put in the SUBTOTAL formulas to get it to function.
Project ID: 10900706

About the project

12 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I know the answer. Just contact me.Regards......................................................................................................
$19 AUD in 0 day
5.0 (149 reviews)
7.3
7.3
12 freelancers are bidding on average $15 AUD for this job
User Avatar
A proposal has not yet been provided
$15 AUD in 1 day
4.5 (2 reviews)
1.5
1.5
User Avatar
A proposal has not yet been provided
$13 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I can do this for you. I have good knowledge of excel. let me know if u are interested in low cost.
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 8 years experience on MIS, currently running training institute on MIS would be happy to help you to the requirement. let me know in case of any further information require. Thanks, Srinivasu.
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$13 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Bendigo, Australia
5.0
1
Payment method verified
Member since May 16, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.