Formula in excel
- or -
Post a project like this2386
$$
- Posted:
- Proposals: 20
- Remote
- #1724556
- Awarded
Spreadsheets|Excel macros and VBA|Google sheets |Google app scripts|Presentations - Tableau, PowerPoint, Prezi|Google data studio
Bay Minette
Transcription,PDF Conversion,Fillable PDF Form,Typing, Data entry,MS Word and MS Excel
Mumbai
1394015148090056410216424923074111824204355852571528136500617628657688311429861
Description
Experience Level: Intermediate
i have enclosed a screen shot of the excel data that i need help with. just so you can see what im working with.
column A has 50000 entries of recurring numbers of which i need to find out which have the best recurring combination of 1 in column D .
column D then needs to be multiplied with column G figure.
example
116559
130983
101934 all recurred 300 times with a column D figure of 1 200 times so the calculation would be 200 times column D minus the 100 times other numbers where in column D
column D 200 x column G 1.52 = 304 minus 100 UNITS from column A total would leave a total of +204UNITS
column A has 50000 entries of recurring numbers of which i need to find out which have the best recurring combination of 1 in column D .
column D then needs to be multiplied with column G figure.
example
116559
130983
101934 all recurred 300 times with a column D figure of 1 200 times so the calculation would be 200 times column D minus the 100 times other numbers where in column D
column D 200 x column G 1.52 = 304 minus 100 UNITS from column A total would leave a total of +204UNITS
Frank M.
100% (11)Projects Completed
3
Freelancers worked with
3
Projects awarded
67%
Last project
9 Jul 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
What does 200 and 100 mean in this formula :
column D 200 x column G 1.52 = 304 minus 100 UNITS from column A -
Do you need Formula or any other tool will work for you which can do the same thing ?
Thanks
Sumit
SaS Technologies
509171508473
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies