I need to process an excel spreadsheet to automatically categorise data
- or -
Post a project like this3635
£20(approx. $25)
- Posted:
- Proposals: 3
- Remote
- #470335
- PRE-FUNDED
- Awarded
Description
Experience Level: Entry
Estimated project duration: 1 day or less
Description of excel work: I need to be able to automatically categorise information in an excel spreadsheet based on a description field.
The description field varies considerably and represents different type of banking transactions. What I would like to do is to based on a word that exists within the description, to categorize that transaction as a particular type, eg,
CASH IN AT 401113 contained in Cell B2
then categorise as CASH in Cell B3
An important point is that the description for a CASH transaction in Cell A1 could vary considerably but I still need the result to return a category of CASH
eg,
CASH LLOYTSB DEC03 NETWORK RAIL@08:48 in A1 would also return a Category of CASH in Cell A3
I expect that there will be approximately 30 categories that will be defined over the entire workbook which need to be extracted from approximately 400 rows.
Extra notes:
The description field varies considerably and represents different type of banking transactions. What I would like to do is to based on a word that exists within the description, to categorize that transaction as a particular type, eg,
CASH IN AT 401113 contained in Cell B2
then categorise as CASH in Cell B3
An important point is that the description for a CASH transaction in Cell A1 could vary considerably but I still need the result to return a category of CASH
eg,
CASH LLOYTSB DEC03 NETWORK RAIL@08:48 in A1 would also return a Category of CASH in Cell A3
I expect that there will be approximately 30 categories that will be defined over the entire workbook which need to be extracted from approximately 400 rows.
Extra notes:
Gurdeep K.
100% (2)Projects Completed
1
Freelancers worked with
2
Projects awarded
25%
Last project
26 Apr 2014
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies