98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Finding missing data
Finding missing data
Resolved · High Priority · Version 2010
Mon 8 Jun 2015, 17:11Delegate Maria said...
Maria has attended:
Excel Advanced course
Finding missing data
Hi,
I have a list of payments on a spreadsheet which I would like to enter onto sage (I cannot import it).
I have entered all the lines into Sage but the totals do not match. The amount I have posted on Sage is under by £1500. How can I compare the data between what I have posted and the list of payments to show lines that are missing from my posted spreadsheet.
Hope that made sense?!
I look forward to a reply
Maria
Tue 9 Jun 2015, 09:20Trainer Jens said...
RE: Finding missing data
HI Maria,
Thank you for the forum question.
Unfortunately I cannot be a great help for you on this one. I do not have any knowledge of Sage but I found some forums which may be can be a help.
http://www.ukbusinessforums.co.uk/threads/import-data-from-excel-into-sage-instant-accounts.184023/
https://www.youtube.com/watch?v=mLOYWfgiWvY
http://www.accountingweb.co.uk/anyanswers/question/excel-sage
I hope this can help you in the right direction.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Tue 9 Jun 2015, 12:25Delegate Maria said...
RE: Finding missing data
Hi Jens,
I don't need help with Sage as I can export the data to an excel spreadsheet.
I need help with comparing the data i've posted with the data from the payments spreadsheet too see what data is missing. the result should be the same totals.
Tue 9 Jun 2015, 12:50Trainer Jens said...
RE: Finding missing data
Hi Maria,
Sorry I thought you wanted to compare your Excel worksheet with your data in Sage.
If you want to compare two Excel lists you can do it with conditional formatting or with the Vlookup function.
Do you have a unique transaction ID for each record (may be invoice number)?
If you have a unique value for each record you can find the two methods used in the attached workbook.
I hope this can help.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
compare lists.xlsxTue 16 Jun 2015: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Select only cell that contain text to lock formatFor selecting cells that only contain Text in Excel |
