...want to merge lat and long data into a website url. I need a formula written that I can merge a latitude and longitude ref into a website URL using data contained in two cells (Lat And Long) in an excel sheet. I then want to drag the code down the sheet creating 1000's of different urls with different Lat and long references...
Hello Freelancers, We need a formula inserted into our statements so that the debit transactions are posted to their corresponding cost category columns. We have 12 statements that need this formula added that will post the amount of the debit to its correct column based on the "Ledger for Reference" column cost category that has already been added
someone to make a shortcut so my computer will say positive affermation (windows 10 A-tts B-editable text input C-loop sort =B(C[Win10[A]])
I have a wordpress website with woocommerce store and would like to have the sorting option to sort the products in the shop by distance. The products are already geocoded with the plugin "Geo my WP".
...Super League of football fixtures in excel. With * automatically score update * I need automatic calculation of average goals per game of every each team -home and away separated * I need calculations of the games without goals (0-0) on every each team. I mean if there will be any results of a game 0-0 I need that to be counted separately of every
Dear Freelancers, I need an ENGINEER to find out a chemical formula in order to make a new product it is a kind of biodegradable plastic. If you are interested I will give you more information about it Best Regards Thomas
...automatically added to sheet: QB Draw Data. When a row is added to this sheet, I need an equation that looks for data in certain columns of the row and adds multiple rows to sheet: QB Bill Import. This equation needs to for each row in sheet: QB Draw Data and the rows will just continue to build in sheet: QB Bill Impo...
This task will focus on the analysis and re-design of a steering wheel with the purpose of reducing it's weight whilst maintaining acceptable stress and d...of reducing it's weight whilst maintaining acceptable stress and deflection levels. The steering wheel cad files will be provided. The optimization should preferably be done using Ansys or Abaqus.
Seeking qualified nutritionist with expertise in vitamins to help formula a liquid vitamin formula. We have certain things we want to use and/or incorporate, but want to make sure we select best dosage, have no vitamin conflicts and make sure all are water soluble. Seeking advice and counsel.
...help with JULY row of fields For the attached form for JULY, if a client were to enter "N" in the empty field, it will count number of "N" under ("Actual # Work Days" minus "Total Work Days Possible") Additionally, if a client were to enter "N" in the field. It will calculate in the "You have used __ NWD ...
add sort by price in homepage and fix watermark in wordpress my bugdet is $2 fixed and good rating + wonderfull feedback
...improved. I would like formulas to relate to a 5x5 matrix and not the 7x5 matrix that is there now. I would also like dropdown tables to relate to the same 5x5 matrix and columns on the register. I also want it cleaned up to suit format. It is a priority task and needs to be done well. I need someone with the skills to get it back quick and get i...
Hi. I have an excel spreadsheet of data and want counts of each of the columns. count by Mr/Mrs count by Job title count by lead/prospect/customer type count by state Someone who is great at building pivot tables would be wonderful - this job is needed immediately.
Let's say a have a single column in excel which has headers and number. Example: *Column A* John 23 4 Peter 54 34 22 12 8 Mark 11 9 8 I need a code that will organize this data into multiple columns where the name appears on top and the respective numbers below. It'll always be names and numbers so the code should recognize the letters and move this
I need a person who is Truly an Expert in Excel. You have to understand how to build formulas and create reports based on the job needed. I am good at excel too but I need someone even better than me, so please bid for for the job only if you are truly and expert in formula building and reports etc.
it is a PHP project. I am trying to add new rows to my tabledit plug in but I have not been able to sort it
I have three websites that are not coming up in generic searches Require someone to come up with a plan to go through each site and rectify initial issues, then assist us to keep the sites relevant in the long term [kirjaudu nähdäksesi URL:n] [kirjaudu nähdäksesi URL:n] [kirjaudu nähdäksesi URL:n]
I need you to develop some software for me. I would like this software to be developed for Windows.
...populates with new data. I need you to lookup data in column A of “Report” sheet and find in “Quickbooks” sheet column B. If found, copy the cell in Column G and display in “Sold” sheet. *The “Quickbooks” sheet can have an indefinite amount of rows *I am using Zapier and created a zap so that...
I have 10,000 names and loan amounts. We needed the loan amount to be displayed with a dollar sign and then have a column show the payment of a 30 year fixed mortgage at 3.75%. This is for a ail merge
...which we need a excel base sheet which help me to calculate employee time and cost which they spent on particular project. Please understand project clearly before you post. 1. We have some different files name IT-1, IT-2...; GST-1, GST-2, COP-1,COP-2 2. Different employee 3. Different employee work on different file so we need to calculate on which
...industry in a list and for every industry does the following: Take the subtotals 1. Sorts the industry entries per sales growth and Highlights the top highest 5 entries in green and the lowest 5 in red. If the filtered results are less than 10 then highlight top half results in green and bottom half results in red. 2. Then for the same industry sort t...
...wich sort them by category, rating... etc. And I need them to sort by a custom field from ACF custom fields named "stardate". But the order should be from the date of today (always) to the future ones, and the oldest ones will not show. You have to document ,in a Word doc, the changes you make in the template and the code that you add....
I need to find the overlapping class of Staff list A with Staff list B. Then count the hr that the overlapped accrued per staff member from List A. Looking for Aid & teacher overlap time total. The info will change from month to month. So needs to be able to work asstaff changes and students Need to get to something like sheet( Need This)
We have data in an excel column that is currently formatted blue,red,orange (plus more colours) we need a formula that we can use in now and in future to reformat it to blue | red | orange | . So replace the commas with "|" beams instead.
I have a large Excel file that has multiple values in one row. I would like those values to be put into their own rows but maintain the information from the other columns. There are 3 columns - Description, Section, Number The number column is the column I want the values to be separated into other rows rather than grouped into one cell, but still
I need you to develop some software for me. I would like this software to be developed for Windows using Java.
Need Excel sheet to calculate Fire Transmissivity. The Fully Developed Fire atmospheric transmissivity τ is calculated by the empirical formula (Fuss S.P. and Hamins A. 2002): τ = a0 + a1L + a2L2 + a3L3 + a4L4 where L = path length, determined by d -0.5Lfcosα. an = coefficient determined by C1n+ C2nTa+ C3nT+ C4nRH. Ta = ambient temperature, approximated
I am intending in launching a cosmetic product and I need someone who is qualified in chemistry and can help me gain the perfect formula for my product. For more information, don t hesitate to pm.
I am looking for a guy who can help me to write few excel formula. Its just few formula, he has to write mostly related to date and payment. kindly let me know. its an urgent job. thanks
Search data in one worksheet and display in another. Quickbooks Sheet = Cognito Export A= AJ B= D,E (no spacing; Exact Order) C= AI D= AK E= C (Day/Month/Year Format) F= AL G= F, G, Y, AO, AP, AQ, AR, AS, AT, M, O, Q, S, U, W, Z, AB, H, I, D (Spacing between each; Exact Order;) H= AH I= E,AI (No Spacing; Exact Order) J= AM K=AN *Data needs to be added