.... I would like to accomplish the "End Result" with the use of a formula only - and NO helper columns. - Array formulas are also fine. ** I don't want to use macros ** ** I don't want to use pivot tables ** ** I don't want to use filters ** I just want a formula or array formula to transform the dataset, into the End Result as shown in the exam...
I have 2 articles done an...Places to Kayak in New Zealand" You will need to change some lines in the article as the previous writer had auckland in mind when writing it. Article 2: You must add 500 words extra to this article. It is currently 1000 words. Make it 1500 words and then proofread it. Article 3,4: Write 2 new articles each of 1000 words.
...there must also be an account for income for each car which shows in fleet management. There must be a place to record loans which you enter the interest rate the deposit the repayment amount and dates. this must be able to be assigned to a car in the fleet management then show on the fleet management page and link to transactions specific to the car. On
... 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.
I have an advertising network script built in core PHP and I'm looking for a full-stack PHP developer to create some extra functions and re-write certain parts of the website into PHP 7.2. I also want to replicate the current design into bootstrap & create some new pages.
Dear Candidates, We Are Looking For: Part-Time And Full-Time Customer Support Individuals To Help Us In Building Good Service Relationship & Provide Better Services To Them. We Need Friendly Male/Female Candidates Who Have Basic Information of Computer, Passionate & Willing To Be Successful With Us and earn Attractive Weekly/Monthly Perks and Rewards For Outstanding Performance Achiever. Y...
...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 immediately *Be available for hourly work over the next
Need formula to calculate day and time for my excel sheet
...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.
I need a little change in my wordpress website. i want to add wallet feature to my website.
PM for more details. Need to be experienced.
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 am looking for a reliable man to work with for long term. You only need to devote 5-6 hours a month and the payment will be $150-$200 monthly. You should be good at English. Please don't apply if you are in India, Pakistan or Bangladesh.
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
I'm using the Listify Wordpress theme which includes a business hours widget that displays opening hours by day and time. I need to add a date column. The widget displays on a front-end submission form, it can be edited in the admin and it is output to a listing page. I've made some progress with this myself but the values are not saving. I am not a coder so you can start fresh or...
Excel quick task, just need to find duplicate records and display data based upon that and filters for based upon dates etc.
I already have an application running on android and apple need more options to be added to it and apply new design 1. The design is ready and need to be apply 2. I need when the user login to take the serial number of the device and send it to the backend i have.
In Google Chrome only, our website has an extra white space in the header. We need that space taken out of the header only in Google Chrome. Website URL is: [login to view URL] I also need to know what code was added in and where it was added.
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.
People for background for photo shooting in Berlin. Men and women from Berlin (25-55 years old). We need 15 extras for 3 location shootings, 2 on 04/10 & 1 for 05/10. We would need them for 6 hours and they only need to be walking in the background during the photo shoots.
...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