Hi Thank you for reviewing my project. This is a quick and simple project for an analyst or expert in Excel to add formula to Excel template to populate it to show the revenue received from orders placed by customers. See the video blow that describes the background and the requirements. [login to view URL] An Expert in Excel
Need formula for google sheets I have a link attach to this. - need to get the sum from T2:T49 for cell O54 but sum need to be filtered by services from column S2:S49. - need to get the sum from T2:T49 for cell O55 but sum need to be filtered by Insurance from column S2:S49. -need to get the sum from T2:T49 for cell O56 but sum need to be filtered
...the game on youtube, dig out all the blogs, newspaper stories... anything you can and come up with your own analysis. A page a Quarter should do it. Here's more info... I'm writing a book about contemporary Australian workplaces and I've found a connection between operational discipline and the legendary 1989 VFL football Grand Final. It explores the
All commetns are imbbded in the Excel file Dashboard SHEET
i am building a spread sheet for my manufacturing business. i need to select a machine and tick its options to be built with on sheet 1. Sheet 2 will need to retrieve and sort data from other sheets and produce a build plan i have a sample layout but it requires the formulas and some experience to set up properly
I need an algorithm that will find the keyword difficulty on google. Factors: -Competing pages -Search Volume -Ranking Position for example i did some seo for my website, then my website shows up on the second page, taking into consideration all the factors above it will find keyword difficulty. -Logic of scientific discovery
I have a cell in excel containing numbers 1 to 90, formatted for example as below 5,68,88 1,75 3,16,68,77 12,34,80 etc I need a formula that will count how many times a cell contains numbers specified, being 1 to 29 and also 1 to 79. These would be presented in 2 new cells as follows based on the above example: 5,68,88 1 2 1,75
I require a specific output of information from details which are in my Excel worksheet.
I have some work, in an Excel spreadsheet. I am in charge of ordering cash refills for ATM machines. The total cost is comprised of several factors, Interest, volume, truck fees etc. The job is pretty simple. My objective is to find the optimum amount for each refill and how often should the refills be. It sounds simpler than it is though. All machines have different volume (cash dispensed). Th...
I have a document with 20 entries. I send it to my coworker and he sends me a second document with notes on specific entries. Each entry has a case number assigned to it. On the first excel sheet (the original sheet) I have 20 entries. On the second document I only have 8 entries with specific case numbers. I need to merge the notes with my original document. See files!
need to kno formula in excel to do columns under coulmns need to kno formula in excel to do columns under coulmns need to kno formula in excel to do columns under coulmns
The syntax (or sentence structure; that is, the way the commands are organized in the formula) of an Excel IF statement is: =IF(logic_test, value_if true, value_if_false). IF statements are used in all programming languages and, although the syntax may vary slightly, the function provides the same results.
I want a formula find the consecutive days in a column that are more than zero ( those days should be 3 or more only , if only 2 then ignore it) then I want to multiply the number of these days in the highest no ( i.e ( 4days *3 ) + ( 3days*4) = 24)) 1 3 2 2 0 1 4 1 0
...when in reality their rent is supposed to start in March. This lack of a proper formula is also a problem if a rent increase happens later in the year like in June...it will apply my increase starting in January and affects the balances Jan-May. I am hoping to find a formula that will pick from a date list and only populate the correct month. I have attached
...brief explanation of the major skincare ingredients used. Accordingly, we would prefer medical/entertainment copywriters. The project will involve basic research (google and writing) A brief out line will be provided for the content to be written. Example of what we want: Ingredient name :1,2-Hexanediol WHAT-IT-DOES: solvent A clear to pale yellow
We are trying to make a dynamic calculation on our "Bid Sheet". The Bid Sheet should be where the calculations final output will be. The "Products/Services" and "Rates" sheets are for reference for the calculations. We want the drop down menu “Item" and “Model" on the Bid Sheet to select the appropriate item on the “Products/Services"...
I am a children's hair salon owner and my partner is a children's hair stylist. We would like to create two all natural shampoo and conditioner formulas for children that smell like chocolate and raspberry. 1 shampoo chocolate, 1 shampoo raspberry, 1 conditioner chocolate, 1 conditioner raspberry. We would like our products to be free and clean: no sulfates, nano-particles, parabens, ...
I need a formula written into cells to identify patterns and then count specific data. The pattern data that first needs to be identified is spread across column B through I. The formula should first recognize the pattern within these cells. THEN according to the search criteria, the formula should match one of three values and produce a value of either
I need a excel/google sheets formula/script to compare the values of: B2|C2|D2|E2|F2|G2 Which ever is the cheapest (ignore cell if there is no data in it to compare): 1 put the value in (I2) and olour code to the supplier 2, Show the diference in value to the next cheapest supplier in (J2)
...pages to be written on strategies for playing the UK National Lottery. For an idea of what we’re after, please refer to the attached example e-book entitled ‘Lotto Master Formula’ which was written for the Texas Lottery. So we need something along these lines that will be applicable to the UK National Lottery. Please also refer to the attached example
Would like to automate my excel for shipping time. Taking into account that we have shipping time and that there is no delivery in the weekend and on monday. Formula has to do something like Friday = Tuesday and Wednesday = Saturday.
Hello, I would like to have a formula or calculator that will give me the true cost of long distance billing that has a per minute cost but bills at a minimum 6 second and then in 6 second increments. This way I can compare those rates to rates that have a per minute cost but bills at 1 second minimum and 1 second increments.
Mapping formula of Cash Flow statement from Balance Sheet and P&L. I will send you BS and PL. and template of cash flow, will require you to put formula at the cash flow statement so that it will automatically calculated.
I need help to make a formula in excel to calculate total investment with compound interest during "x" years. a) Years (Can be edited by user) b) Inflation % (Can be edited by user) c) Yearly investment (Can be edited by user) d) Total Invesment + Inflation "b" during "a" years Need to get a formula NOT using excel FV function.
...proprietary plant-based organic supplements. We have lists of the supplements our manufacturers offer to create our own proprietary blend. This is extremely helpful. However, if the formula we need to create falls outside of what they offer we will need to shop a new manufacturer. We need your help to bring a new level of effectiveness, safety, and transparency
please check attached file i want to match Column C-2 of sheet2 with Column-C of sheet3 if matched, then Column-M of sheet2 reflects in ...i want to match Column C-2 of sheet2 with Column-C of sheet3 if matched, then Column-M of sheet2 reflects in Column-M in sheet1, otherwise INSTOCK i'll pay 5$ for this formula i am looking to discuss thanks
Excel Formula Needed For My Inventory. I have 2 Sheets 1ST Sheet is my Inventory Sheet named "2018" Serial Numbers are placed in Column "C" in Sheet 2018 2ND Sheet is my Sold sheet named "Sold05/02/2018" Serial Numbers are placed in Column "c" in sheet "Sold05/02/2018" In sheet "2018" Column M has the value "...
The project is to adjust an advanced excel formula used in a commission calculator. The requirements of the formula are outlined in the below scenarios: CURRENT FORMULA June billed revenue 100,000 July voided revenue -100,000 A negative threshold carryforward applies at a fixed value 34,999 applies to July which will carryforward to payables
Formula/Template Print different address on the brochure
...will not get a response. I am given price files in Microsoft Excel from Vendors daily. Many of them are not formatted in the way I need them. Some formula(s) could help me out. I need an Excel Formula(s) that I can use over and over again to: 1. Start with a value in a column marked 'UPC' 2. Find the same exact value in another column marked 'UPC
create a macro or formula to convert text to number in column "G" and place the number value in column "L" Example "-975 " is in column "g" it is stored as a text, place the number value in column "L", remove the spaces This can either be performed as a formula or vba macro This is a micro project, budget $5/ to be completed in 1 ...