||Please work on this function.
||Jan 5, 2014
||Jan 5, 2014Ended
||Need a function in Excel spreadsheet that would check to see if a sum of any combination of a specified
||PHP, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||Feb 13, 2004
||Feb 13, 2004Ended
||...modify Excel function shown in the link below: http://tinyurl.com/ycpzmw9 The current function removes...are upper case letters A-Z and numbers. The new function should also allow lowercase letters a-z and the...Worker Legal Agreement).
Microsoft Excel, VBA
||PHP, Visual Basic, .NET, Script Install, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL, Visual Basic for Apps
||Apr 10, 2010
||Apr 10, 2010Ended
||Please work on this function.
||Mar 10, 2014
||Mar 10, 2014Ended
||I would like an excel function that will produce a list which concatenates as follows:
||PHP, Software Architecture
||Sep 25, 2013
||Sep 25, 2013Ended
We are looking for an excel expert to help us with a functions/formulas for one of our clients...clients eCommerce solution.
The function we are needing has to link cells AM1 (values in red) to G2...on which values/cells we are linking up, as the excel document will have more than 100 values that need
||Jul 13, 2010
||Jul 13, 2010Ended
||...the data from an other sheet using the VLOOKUP function.
Suppose to have a list of articles in the "Sheet...have different size and resolution.
So I need Excel to resizes them keeping the aspect ratio, manages...least I guess) and Excel look for the file/s in the folder.
If the file exists Excel analyzes it, resizes
||Nov 26, 2008
||Nov 26, 2008Ended
||5 excel functions required for 10 to complete the task
||Apr 25, 2015
||Apr 25, 2015Ended
|Excel IF function
||...create 2 Excel IF functions. It is hard for me to explain but here is an example and using the Excel file...provided this will help explain what I need
Excel function 1
Start in cell CV3
=IF A3="ALBANY"...continue until Wyong 2100 ( see line A265 )
Excel function 2
Start in cell CW3
||Jul 4, 2012
||Jul 4, 2012Ended
|286537 Excel Function - DeleteRows
||We need some help with an Excel function that would delete the entire row(s) based on values of certain...should be fairly simple for someone familiar with excel. PMB any questions or concerns before bidding on
||Visual Basic, Data Entry, SQL, Microsoft Access, Anything Goes
||Feb 5, 2009
||Feb 5, 2009Ended
|Make Excel Function (VBA)
I need a function, see below.
'The function should take the colour from the product name
...from the array
' - Join the array with "|"
Function COLORFROMNAME(cVal As String) As String
COLORFROMNAME = result
||PHP, Visual Basic, Software Architecture, Visual Basic for Apps
||Nov 11, 2014
||Nov 11, 2014Ended
|User Defined Excel Function
||Create a user-defined function that can be used to output the value in the look-up table. Such as: coxsprague...Agreement).
Windows 7.0 MS Office Excel 2007
||Engineering, Software Architecture, Software Testing
||Aug 12, 2010
||Aug 12, 2010Ended
|Need to add an Excel function
||Need to add an Excel function that does the following:
I have a validation list in one cell that i...supposed to be easy, but it just don't know the function for it.
this is a one-time job.
||Oct 25, 2014
||Oct 25, 2014Ended
|excel function for distance calculator
||...within india into km (around 4000 destinations) in excel
||Excel, Google Earth
||Nov 28, 2014
||Nov 28, 2014Ended
|Add some Excel function
||...need a working file ("Planning.xlsx) with some function (create list, change color in some case)
||Data Processing, Data Entry, Excel
||Nov 21, 2012
||Nov 21, 2012Ended
|VB function for Excel
||Excel has built in functions such as COUNTIF(range, criteria) and SUMIF(range, criteria, sum_range)....MinIf(Check_Range, Criteria, Data_Range) and MaxIf. Each function should accept ranges and a criteria, similar to...And( $ <=10, $ >3) OR ($ = 6.55). Ideally the function would work like SumIf in that the criteria could
||PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL
||May 6, 2006
||May 6, 2006Ended
||**Deliverables: Two Excel Formulas or Excel Functions (Preferred), as described below:
I need two...two closely related Excel formulas that will take the text data from a spreadsheet and modify it to create...below.
1) Description of the first formula or function:
This formula will concatenate the product
||PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||Dec 15, 2008
||Dec 15, 2008Ended
|Excel Function - Hyperlink
||...review the attached spreadsheet.
I'd like a function that will create a hyperlink from a spreadsheet...coder's Seller Legal Agreement).
||PHP, Windows Desktop, Linux, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, Chrome OS, MySQL, UNIX
||May 18, 2006
||May 18, 2006Ended
|Excel function in VBA
||...create a function In Excel - I should be able to import a text file - and then import 2 or 3 excel files...imported excel files - export the "modified excel file" to a text file - Ready !
This excel function are
||Visual Basic, Excel
||Jul 12, 2012
||Jul 12, 2012Ended
|315982 Excel Function
||...basic excel formula to calculate the actual time difference between two dates.
Please use an excel formula...NO macro's or VB scripts.
I have attached an excel doc to show what I required.
The Create and Resolved
||System Admin, Data Entry, SQL, Microsoft Access, MySQL, Anything Goes
||Apr 30, 2009
||Apr 30, 2009Ended