... This shows an example of my 'dataset', and the layout of how I would like it to be transformed... Ideally, I would like to accomplish the End Result with the use of a formula only - and NO helper columns. I have colour coded the data to make it easier to read. Please take a look and let me know if you are capable of helping me. Thank you very
1. Help find 60 mom&baby, shopping, or baby product related to Facebook or Instagram accounts 2. Reach out to the accounts and ask them to help post product related posts 3. Increase the brand exposure and awareness over FB/IG
1. Formula for Markup 2. Formula for Volume Pricing A. I have 3 files, same format on each file. Each file has Inventory Sheet & Markup sheet. I (amatear) have used (If) formula, I know you can do better. B. I have try to have volume discount formula and failed. I use hidden columns. I use Teamviewer.
Please don't bid without looking at attached worksheet. If you do, I won't even consider your offer. I have written a complicated pricing program in Excel and need assistance finishing it. For this moment you are bidding on debugging the macro "Building 1" Located on the "Quote" Worksheet. The winning person will: *Have advanced knowledge of Excel. *Be able to start...
Shopify expert to use CSV file to change prices from cost price to retail. We imported around 2000 products and used the wrong column so all our retail prices are actually our cost prices. I could do it myself but we need to hire a person as our outside freelancer for all things shopify. So this is a nice test job. If you are also wiz at theme updates
Need formula to calculate day and time for my excel sheet
...Experience Manager (AEM) into a CSV file. The files from AEM are in XML files that are in a Java Content Repository (JCR) format. Each XML file is in its own folder, in the format of: year/month/day/article-title/[login to view URL] You would need to loop through each folder and add the contents of each file into one line of the CSV file. The end result would
I have multiple websites which I need create some user accounts on a daily basis. I need these to be automated using scripts and these scripts should take feed from text or CSV file
...square meter (m2) price. I need a formula for pricing. Example: A sign is A:190mm x 190mm for $30 (works out to $831/m2). A sign B:290mm x 290mm sells for $58 (works out to $689/m2). If I only work on the Square meter price of Sign A, Sign B would be $69.88 and would be too expensive. So I am looking for a formula that should a sign increase in size
I need a formula or macro to extract URL’s and text between <a href> and </a> tags. There could be up to 20 occurrences per cell. All links merged into one column, and all the text between the anchor text in 1 column. I do have a formula in sheet 1, cell D, but its not correct. I need it to be extended to cater for 20 occurrences per cell, as well
...VERBS % DETERMINERS % ADVERBS % PRONOUNS % ADJECTIVES The % is defined, but not in above example, since this post is public to freelancer.com. What I Need is mathematical formula or algorithm that states, Based on the % that totals 100%, a paragraph, will be made up of those % percentages. Say Common Nouns is 10%, there would be 10% nouns in the paragraph
Need someone who can help with matching two different sheets in excel i.e. GDP growth rates for specific countries in specific years (in one sheet) and matching this with a new column ''GDP Growth'' in a sheet with premiums for M&A-transactions.
Need a google sheets array that identifies running 7 days Example of my weekly formula that returns if its in a week or not. now i really want running 7 days =ARRAYFORMULA(if(weeknum(today())=weeknum (A2:A19526),"Week",""))
I need someone to design cars chassis,body panels,upright and hub,intake,and fuel tank. knowledge of vehicle dynamics and suspension working is required .
Hello. I have an issue with open office, please see the attached spreadsheet. As you can see, the boxes that are highlighted I would like those 2 numbers separated and put into the next cell over. Example, Under the FG tab in K10 there are 2 numbers which appear as 29-70. I would like the 29 to stay in K10 and the 70 to move to L10. For all of the highlighted boxes to move over into the next cell ...
I am a retail trader having 2-year exp in trading. I want an AFL on conditions. BUY SIGNAL = I heikanshi candle turns green and closed, I want system to fire buy order to my broker terminal. SELL SIGNAL = If heikanshi candle turns red and closed in red, I want system to fire sell order to my broker terminal. I will be using (1 & 5 ) min candle chart for trading.
I need to add products and categories to my menu using csv file in bulk... ONLY APPLY IF YOU UNDERSTAND THE JOB. I DONT NEED TO ADD PRODUCTS AND CATEGORIES MANUALLY IT WILL TAKE TOO LONG...
On the link below you will find a Google Sheet: [login to view URL] A need a formula on columns F2, F3, F4, F5 that shows the word coincidence between the columns on the left. For example, the sentences "Hello, this is an example." and "Hello, this is an example." have
Excel quick task, just need to find duplicate records and display data based upon that and filters for based upon dates etc.
I have an business renting homes on Airbnb and want a clean, easy to use table to view the revenues data in. When I download the csv from Airbnb I have these issues: -the date format is unreadable and needs a manual fix each time -i use the sum function and have to manually pick the rows for each listing It shouldn't be too difficult to do on VBA
Hi, I need an Excel formula or VBA function that will extract all occurrences of a string, it’s an src=“[login to view URL]*/*” string, where the * can be different text. There can also be multiple src strings in one cell. I need all the src strings to be copied into a new column. File will be shared in messenger.
...details of a complete directory of dozens of Excel .xlsx files each with multiple Worksheet Tabs in every Excel file each containing multiple Column Name Headers into a single CSV file with a single row for each of the unique Excel .xlsx Worksheet Tabs in the Workbook and all the Column Names contained in that Worksheet Tab formatted as follows for each
...products (problem here is that there are more than 200k lines (200000) But could split them into several sheets Example is within the sheets link aswell, I basicly just need a formula that is able to calculate every below cells until the next empty cell. https://docs.google.com/spreadsheets/d/1TS-OkJ8aokBqXyut0_XWCDp5RQ38-WnqBlU_z8fPNlU/edit#gid=0
...generate the following formula please: - Column E on our excel sheet has times populated in them - the times are usually minutes (for example 21 minutes OR 30 minutes OR 33 minutes OR 1 hour 10 minutes) etc - we would like a formula creating which we will place into an adjacent new column (let's call this column X) - the formula should automatically result
...in sheet 2 a formula which is connected to a filter which shows me depending on the filter I choose in sheet 2 only particular rows from sheet 1. Sheet 1 will be replaced monthly. Sheet 2 should be programmed that it pulls the numbers from sheet 1. An easy way to illustrate is Pivot table. The only thing is that I need this all formula based, maybe
...a certain period X (variable, in # of days). So if X is 30, the formula would look at the average frequency of 'actions' (ie: in days) over the past 30 days. If X is 60, over the past 60 days, etc. See sample under Additional Project Files. I'm looking to fill C10:C2033 with a formula that would check, over the last 30 days from a certain date (CELL
...that all use the same Point of Sale software (Junction 6). This software has been configured to generate and email a daily sales report once every 24 hours that attaches as a .csv breakdown of sales every day. We would like this dropped into a Google Sheet so that we can have an Automatic Daily updated report (dashboards are linked to this Google Sheet)
My name is Pilar, I am working on building an excel for tax calculation purposes and I am running into some trouble with a formula that I cannot build-in on my own. The excel is basically an annual gain/loss stock portfolio statement that takes the dollar amount of the purchase and sale proceeds and converting it into the official Mexican peso rate
This should be a quick formula to pass my way. Just need an "IF" formula. As you can see, in Column "A" I will be selecting the status of the MSR, and need it to auto fill the applicable total to the appropriate cell on the right (Received, In Progress, Complete, Shipped) No need to bid on this, as I have a freelancer already lined up
Help me with Sensitivity analysis, Monte Carlo simulation, optimise the LCOE formula. I have done some part of the work and I need you to improve the overall paper and also help with Sensitivity analysis, Monte Carlo simulation, optimize the LCOE formula. More details will be shared. Thanks
I NEED AN EXCEL FORMULA CREATED FOR A HYDRAULIC LOSS PIPE CALCULATOR, I WILL PROVIDE A VIDEO OF ME DOING IT THE LONGHAND WAY (BY HAND) I WILL THEN NEED YOU TO CREATE AN EXCEL PROGRAM FOR THE CALCULATIONS TO BE AUTOMATED - THE CALCULATIONS WILL BE BASED OF INPUT DATA EXTRACTED FROM A COMPUTER PROGRAM, THIS DATA WILL INCLUDE PIPE SIZES, LENGTHS ETC.
Hi there, I have two documents. One shows: * Post code * Names of customers The other shows: * Post code * Longitude * Latitude I need the first document to ALSO show long & lat for all listed postcodes. that's it. So, long/lat' from sheet 2 need to be put onto sheet 1 I need it immediatetly. Very easy job.
I made a robot it has 2 motors and 2 encoders attached the encoder....motors and 2 encoders attached the [login to view URL] reads the value from the wheel and display on ROS and I can see the movement on RVIS but the movement is not correct so the formula might need to be fix [login to view URL] works fine but I will like to combine that code with [login to view URL]
I have ongoing work related to our previous project 'I need an Excel expert to help me find a solution to this problem via a formula or macro'