|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
|High Yield Investment Page - Custom Script
- support/ticket system
Code should be fully decoded.
Should contain simple
||PHP, Website Design, Graphic Design, MySQL, HTML
||Sep 11, 2014
||Sep 11, 2014Ended
||Data Processing, Excel, Microsoft Access
||Jan 11, 2015
||Jan 11, 2015Ended
|VBA code Excel task
||I need to make VBA code that will do following.
I need to refresh data every x minutes.
So data would...copy row(s) to next sheet.
We can use VLookup function or similar to compare are data new.
||Visual Basic for Apps
||May 4, 2013
||May 4, 2013Ended
||5 excel functions required for 10 to complete the task
||Apr 25, 2015
||Apr 25, 2015Ended
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
|Excel Code needs to be written.
||Alright, so I have already had this code written before, but now it somehow corrupted and won't allow...someone to fix the code, or re-write the code to function again.
To sum up the code and how it needs...am inputting Hex Codes into the document. I need excel to add a column before each of the columns of hex
||Excel, Visual Basic for Apps
||Dec 11, 2012
||Dec 11, 2012Ended
||Please work on this function.
||Mar 10, 2014
||Mar 10, 2014Ended
||...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
|Bar code Scanner into Excel
||...have the need to maintain an inventory using MS Excel. I want to scan the serial numbers of systems, and...by hand, and needs to stay in Excel or StarOffice format (prefer Excel, I can convert as needed).
...currently scanning the serial numbers into the find function to search if the system has already been entered
||PHP, Windows Desktop, Linux, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, Chrome OS, MySQL, UNIX
||Feb 28, 2005
||Feb 28, 2005Ended
|Basic function to access VirCurEx using Excel (VBA)
||...using SHA2. The following example code may help. However use any other code that you can find that will perform...perform the SHA2 function.
SHA2 VBA Script
The final code should look something like this. However can be
||Visual Basic for Apps
||May 22, 2013
||May 22, 2013Ended
|asp code instr and replace function quick fix
||...I am stuck on this asp code, driving me nuts:
I have a forum in asp code with mysql backend, I moved...displays images, but I cant seem to get the replace function to work properly.
1. <http://militaria...Attached is the code in question [topic.asp], pls look at line 159-171
along with an excel dump of the
||PHP, ASP, Visual Basic, Engineering, Software Architecture, Software Testing, Website Testing, MySQL, Amazon Web Services, Website Management, Web Hosting
||Jan 2, 2006
||Jan 2, 2006Ended
||I would like an excel function that will produce a list which concatenates as follows:
||PHP, Software Architecture
||Sep 25, 2013
||Sep 25, 2013Ended
|Call Excel xla function in VB (MS Access)
||...want to call Excel xla functions in MS Access.
CUMPRINC function (you need to...to enable Excel Analysis ToolPak-VBA first)
We want to call "cumprinc()"..."cumprinc()" function in MS Access
we tried follows, but both didn't work
Public Function xx(rate
||PHP, Visual Basic, Engineering, Software Architecture, Microsoft Access, Software Testing, MySQL
||Apr 14, 2004
||Apr 14, 2004Ended
|Fancy Excel Payroll sheet with lookup function
||Attached is my payroll excel worksheet. My goal is to automate and clean it up.
What you need to know...program(s) in executable form as well as complete source code of all work done.
2) Installation package that...Agreement).
windows 2000 / xp
excel 2000 / xp
||PHP, Windows Desktop, Linux, Engineering, Excel, SQL, Powerpoint, Software Architecture, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, Chrome OS, MySQL, UNIX, Database Administration
||Mar 2, 2004
||Mar 2, 2004Ended
||Feb 19, 2013
||Feb 19, 2013Ended
|Excel VBA time-series validation function
||This function must analyze a 2-column time series data (column1: timestamp or date, column2: numerical...specified by Input #4 below.
This function must analyze a 2-column time series data (column1:...error checking. Works for Excel 2003, 2007, 2010, XP and Vista. Source code will be provided to me, and
||Windows Desktop, Microsoft, Visual Basic for Apps
||Nov 1, 2010
||Nov 1, 2010Ended
|168666 Convert Excel RATE() into Code
||...that replicates the Excel function RATE(). The RATE() function is used in Excel to calculate the comparison...understand the simple maths behind the RATE() function**
Previous work: Provide only 1 example a of
||Sep 27, 2007
||Sep 27, 2007Ended
|SQL Code In Excel
||...spreadsheet. Can you make? in a? macro a User Defined function so that I could put functions in the cells in...formula in a new column.
Here is the sql code to call the relevant columns in the table? I am
||PHP, Project Management, Engineering, SQL, Software Architecture, Software Testing, MySQL, Visual Basic for Apps
||May 19, 2009
||May 19, 2009Ended
|Excel - VBA format function for numeric values
||...create a function which I can use for formatting input values in an Excel VBA form.
The function should:...program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in...Seller Legal Agreement).
Microsoft Excel 2000 and later
||PHP, Windows Desktop, Linux, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, Chrome OS, MySQL, UNIX, Visual Basic for Apps
||Nov 7, 2006
||Nov 7, 2006Ended