In Progress

Excel count formula

Hi this should be a quick project for the right person.

1st I need this done very quickly please (hence why I'm here in the first place otherwise I would do it myself).

I have 3 tables one has a list of sites for clients in the 2nd I have a list of clients with audit dates e.g. start and finish and in the 3rd is the raw data. All 3 tables connect to a database so change so your formula needs to work with tables which update.

What I need is a count formula being made to based on these 3 tables in the 1st table the site listing to found out how many times the site has been audited in a given period.

I have created a demo file attached so you can view and see.

Thanks

John

Skills: Excel

See more: Excel work based jobs, what kind of database stores data in dimensions, formula excel work hour, home based part time excel work, excel work home based, home based excel work, formula projects excel, actual formula rate excel, script count excel files folder, sharepoint formula count creator, formula directa excel, design excel work update excel workbook, formula sheet excel, cuando una formula directa excel, formula creator excel, paste formula vba excel, free formula aging excel, cash drawer count excel, formula rate excel, formula function excel, rank formula options excel, run excel vba select update filed based criteria, time count excel, website needs update, galveston work needs done

About the Employer:
( 50 reviews ) Arlesey, United Kingdom

Project ID: #14373827

Awarded to:

avinav606lx

Hey John, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. More

£23 GBP in 0 days
(113 Reviews)
6.1

21 freelancers are bidding on average £22 for this job

SBITServices

Hello Johnhoube , I have read your project description and checked the file and understood your requirement. I have 5 years experience and Check our reviews to confirm our work quality(100%completion rate) Relevan More

£20 GBP in 1 day
(146 Reviews)
6.7
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind o More

£40 GBP in 1 day
(156 Reviews)
6.7
shafaqat11

Hello Sir, Thank you for posting the project. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I am a hard worker, productive and worthy of More

£13 GBP in 0 days
(66 Reviews)
5.2
tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start

£23 GBP in 1 day
(77 Reviews)
5.2
Bestever786

Hello dear sir how are you hope you are well Dear sir I am Expert in Data Entry and in all the tasks on Excel Spread Sheet if you really want 100% Error Free and Quality Data Research and Data Entry Work done Manu More

£30 GBP in 1 day
(9 Reviews)
4.6
BAVarun

implementation of count formula in excel for audit Relevant Skills and Experience 10+ years in excel and all the 54 reviews on my profile are for ecel with over 4.9 average Stay tuned, I'm is still working on this p More

£26 GBP in 1 day
(31 Reviews)
4.5
younus15

Hello. I have extensive experience in Excel, Coding and Data processing.I can do your project in less than a Day according to your description with full delivery and without error. I would also complete your project More

£44 GBP in 1 day
(27 Reviews)
4.2
ketas

Dear, I could hep you to make it done within one hour only .

£28 GBP in 0 days
(8 Reviews)
2.4
£28 GBP in 1 day
(1 Review)
1.9
sameralbaroudi

Ready right now Relevant Skills and Experience Excel Proposed Milestones £10 GBP - job done

£10 GBP in 0 days
(1 Review)
1.3
PujaKumari123

Dear Sir, I have 4 year experience of Excel. I am able to provide this project quickly. please give me chance to work, I will not make you regret. Thanks, Puja

£18 GBP in 0 days
(0 Reviews)
0.0
Shazz009

I already doing the job on Excel basis I will give you 100% best result... and i will give you free sample if you want Relevant Skills and Experience I already doing a job in excel basis.. i already make many excel sh More

£18 GBP in 3 days
(0 Reviews)
0.0
shangray2009

I have knowledge of excel and formulas.I can do the task for you. Relevant Skills and Experience I am working as a Balanced Scorecard Coordinator.I deal with the formulas and excel for analysis purpose. Proposed More

£10 GBP in 1 day
(0 Reviews)
0.0
MKB14

I'm an engg, currently on medical leave. Hence wanted to utilize time productively and bidding. Asure for the timely completion. Best of luck.

£18 GBP in 1 day
(0 Reviews)
0.0
NiveaGarg91

A proposal has not yet been provided

£23 GBP in 1 day
(0 Reviews)
0.0
meghamallick

I have done similar exercise earlier for my school where I was teaching. I had to develop a small model in excel to track my student's information and do analysis on the same. Relevant Skills and Experience excel Pro More

£10 GBP in 1 day
(0 Reviews)
0.0
£21 GBP in 2 days
(0 Reviews)
0.0
karthicksr2009

Macro can do anything in excel Relevant Skills and Experience Excel VBA, Macros Proposed Milestones £18 GBP - Formula, Macro

£18 GBP in 1 day
(0 Reviews)
0.0
HaseebAspirant

have beginner luck

£13 GBP in 1 day
(0 Reviews)
0.0
ahmedgamal2601

A proposal has not yet been provided

£23 GBP in 2 days
(0 Reviews)
0.0