Hall
$30-250 USD
S-au achitat serviciile după ce au fost prestate
Summary
My problem is the formulas in my current spreadsheets are too long and difficult to read. I wish to shorten the formulas and be able to change the contents of 1-2 cells and have the results of the output change. Hope this is clear so far. I am not looking for any macros to do any of this automatically.
Detail
I have one spreadsheet called FE. It has 52 columns and the number of rows varies from month to month. This is my source spreadsheet. It has 3 ranges of cells in 3 different columns. The ranges I call Invoice, Tracking and Net.
I have another spreadsheet that pulls data from FE. Call it RECONCILE. It will have the same number of rows as FE. Data will be pulled into RECONCILE even if FE spreadsheet is not open. Data is pulled into RECONCILE based upon the Tracking number. Data will be pulled from the spreadsheets based upon cell months in the RESULTS spreadsheet. Thus if 0119 is in cell G1 and 0219 is in cell G2 then data will be pulled from FE spreadsheet ending in 0119. If there is no data in that FE spreadsheet, an additional attempt will try the FE spreadsheet ending in 0219.
The formula I have been using is "IFNA(INDEX([login to view URL]!Net,MATCH(E15,[login to view URL]!Tracking,0)),INDEX([login to view URL]!Net,MATCH(E15,[login to view URL]!Tracking,0)))". Thus if the data does not exist in the spreadsheet ending in 0119, the spreadsheet ending in 0219 will be tried. If there is no match between the 2 spreadsheets, a 0 should be returned.
Month to month the name of the spreadsheets and the data it holds change The spreadsheet name changes, but only the part related to the date. For example, "FE_Month_013119", "FE_Month_022819", etc.
ID Proiect: #18828793
Detalii despre proiect
10 freelanceri plasează o ofertă medie de 91$ pentru proiect
Greetings! I understand your problem. However, the length of formula cannot be changed significantly. But there is a possibility of not having to worry about the formula updates month to month. It is possible to set Mai multe
Msc computer science. MBA accounts and finance. Mphill in statistics. having seven years of experience in Excel vba and Excel macros. I already done many Excel complex projects like: Excel models designing. Exce Mai multe
Hi there! Have done this type of work before and am an excel expert! Please feel free to message me with additional information such as the xls spreadsheets or with questions if any, thanks!
Hello I have a lot of experience in data typing, data entry, web research, database administration, ad posting, data research, data mining, data extracting, data scraping, virtual assistant. I saw your project and I Mai multe
Hi. My name is Juan Carlos and I'am an Excel expert;. I have the skills to develop the job you need and improve it (please take a look at the example included in the portfolio); I can carry it out very quickly at a Mai multe
Dear Employer, I have over 10+ years’ experience in Micr0soft Office. I have worked for clients from India and Overseas. Services offered: * Excel * SEO Specialist * Data entry * Data Processing * Microsoft Offi Mai multe
I can typing fast.I have work experience in Excel,Word,Data entry,copy typing,copy writing,copy editing.
From the message, I understand that the additional attempt to find the new transactions for new month FE may cause the long formula. My proposal is to find the additional transactions in new month FE with vlookup and Mai multe