Project Name | Description | Bids | Skills | Started | Ends | Price (USD) | |
---|---|---|---|---|---|---|---|

EXCEL CONCATENATE/FORMULA/SCRIPT/MACRO Data manipulation | We use EXCEL 2003. I think this task requires someone with a good knowledge of EXCEL formulae and probably...piece of text to the end of each title,
a maximum number of characters to be shown per title (any words...JOIN3..........JOIN4..........JOIN5 together
(Concatenate?) and insert a space in between each word. Any |
18 | Visual Basic, Data Processing, Excel, Microsoft | Mar 11, 2010 | Mar 11, 2010Ended | $72 | |

Data entry with Barcode Scanner Macro/Formula for Excel | I need a Macro allowing us to record entries into a spread sheet via barcode reader. The 3 items are...are Sales Order Number which is 7 numbers, Part Number which can vary from 7 to 20 alpha numeric values...values, and a Serial Number that begins with a letter followed by 8 numbers. The goal is to have one spreadsheet |
6 | Data Entry, Excel | Aug 19, 2013 | Aug 19, 2013Ended | $80 | |

Data Processing, Data Entry, Accounting, Excel | May 25, 2009 | May 25, 2009Ended | |||||

Macro to concatenate fields into new worksheet | Need a macro to concatenate ??" fields from one worksheet in to cell in another worksheet
Need master...cells from C3 on
Button Macro: Look for the Column header and concatenate Fields into “new worksheet...coder's Seller Legal Agreement).
## Platform
excel 2000 |
4 | Anything Goes | Sep 16, 2008 | Sep 16, 2008Ended | $22 | |

Excel macro Formula | ...product code from data set. Need to build a macro or formula that will discover what other products were...were sold alongside it, (grouped by Sales Order Number), & by Customer.
Need to expand data each month...month, so will need to modify data and rerun macro / formula each month. Have attached example |
5 | Visual Basic, Excel | Feb 19, 2015 | Feb 19, 2015Ended | $79 | |

Excel formula | Buyer needs a formula that evaluates a number of columns in the row to determine what it's value should...rules of the formula are listed below and should be evaluated in this order:
1) If cell P has a valid...valid date value make cell A say “Lucid ” + date value of cell P
2) If cell P does not have a valid date |
57 | Excel | May 7, 2013 | May 7, 2013Ended | - | |

Excel Macro/Formula Expert | ...simple project for an expert in Excel Macros and Formulas. We have a number of csv files that we need to...really need someone who is an expert. This macro/formula must work for other csv files as well. The data |
4 | PHP, Engineering, Game Design, Software Architecture, Software Testing, MySQL | Jan 5, 2007 | Jan 5, 2007Ended | $23 | |

Excel | May 15, 2011 | May 15, 2011Ended | |||||

Auto Gantt in Excel Formula/Macro | Hi,
I need a formula to show a gantt chart in excel. What this formula should do is as follows:
...
1. In a cell (assume C7), the formula should check the date in the header row. (Assume C1)
2. The...The formula should then check the date in the corresponding start coulomb (assume A7)
3. The formula should |
2 | PHP, Software Architecture | Jul 8, 2015 | Jul 8, 2015Ended | $24 | |

excel macro that executes a formula for values in a pivot table | I am looking for an macro that calculates an index = 1 minus the Herfindahl Index for companies listed...you could e.g. compute intermediate steps of the formula in the columns next to the pivot table.
How...class
H = sum of square(number of products in class i and year j/total number of products in year j) for |
12 | Visual Basic, Data Processing, Excel | Jan 29, 2014 | Jan 29, 2014Ended | $34 | |

formula to find text in Excel | Hello,
I need a formula to find where text starts in Excel. THIS IS NOT to find specific text - it...[first part of the cell has spaces - anywhere from 1 space to 100 or more] so the cell would look like this:
...what the letter or number or special character will be. Maybe a way to do the formula it is to tell me |
6 | PHP, Visual Basic, Software Architecture, Microsoft | Dec 25, 2013 | Dec 25, 2013Ended | $23 | |

concatenate excel cels, using VBA | ...the column B it's the number of lines for the same Report ID, generated by a formula (countif)
- in the...column C it's the number of line where it starts that Report ID,
also generated by a formula;
- in the column...column D it's the number of line where it ends that Report ID;
also generated by a formula;
what I need |
1 | Visual Basic, Microsoft Access, Visual Foxpro, , Visual Basic for Apps, Windows API | Feb 18, 2015 | Feb 18, 2015Ended | $39 | |

VB Macro OR formula for excel sheet. | I have excel with multiple tabs. I need a button that will generate report pulling information from multiple...tabs. Tabs could be added removed and renamed. So formula/algorithm should be able to pick this up.
Report...report. Cell colors should be reflected in the report as well.
In addition i have one formula that needs |
41 | Visual Basic, Excel | Feb 15, 2015 | Feb 15, 2015Ended | $27 | |

Excel Formula | Require an excel formula created to calculator living expenses.
e.g.
Number of Adults = > Input...Input number
Number of Children = > Input number
Table:
1 Adult 0 Children = 1000
1 Adult 1 Children...will be able to enter a number in (Adult) cell 1 or (Adult) cell 2 and the formula will search for the correct |
37 | Excel | Jan 23, 2014 | Jan 23, 2014Ended | $19 | |

concatenate csv files and adjust existing macro - repost | ...have an excel macro that just needs a little adjusting. We need to be able to import any number of csv...that the current macro runs on. Then there are just a few adjustments needed to the macro, filtering and...
Needs done asap.
Please note this is for Excel 2011 Mac, so reference to Microsoft Scripting Runtime |
10 | Excel, Mac OS | Mar 11, 2013 | Mar 11, 2013Ended | $109 | |

Excel Expert needed for macro or formula | I have an excel spreadsheet that is pulled from an external data source. I need to make a simple calculation...with the minus sign on the "wrong" side of the number. I need to be able to identify those numbers as |
15 | Excel | Dec 8, 2011 | Dec 8, 2011Ended | $32 | |

416689 Fast Simple Excel formula | Please feel free to use--whatever functions,IF or Macro. I need this as soon as possible so I will take...to complete.
-Simple excel formula, macro or procedure to help assign "number" (column D) to each new...should enter Proc as shown.
b)For each new part number added into the list, it is classified by assigning |
1 | Excel, Anything Goes | May 26, 2010 | May 26, 2010Ended | $10 | |

excel macro that executes a formula for values in a pivot table - repost | I am looking for an macro that calculates an index = 1 minus the Herfindahl Index for companies listed...you could e.g. compute intermediate steps of the formula in the columns next to the pivot table.
How...class
H = sum of square(number of products in class i and year j/total number of products in year j) for |
4 | Visual Basic, Data Processing, Excel | Jan 30, 2014 | Jan 30, 2014Ended | $7 | |

EXCEL IF formula | I have an Excel spreadsheet that downloads stock market data every day and calculates the range that...that the stock market will stay in over x number of days, ONLY when certain IF criteria are met. If they...current criteria, I want Excel to look back over the specified number of days (cell P2 in the spreadsheet) |
4 | PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL | Apr 23, 2009 | Apr 23, 2009Ended | $29 | |

concatenate csv files and adjust existing macro | ...have an excel macro that just needs a little adjusting. We need to be able to import any number of csv...that the current macro runs on. Then there are just a few adjustments needed to the macro, filtering and |
2 | Excel, Mac OS | Mar 10, 2013 | Mar 10, 2013Ended | $92 |

Showing 1 to 20 of 410448 entries

753

154

209

171

336