Excel Challenging - Please Help
Closed
gutoazuk
gutoazuk
- Posts
- 3
- Registration date
- Sunday July 5, 2015
- Status
- Member
- Last seen
- July 6, 2015
gutoazuk
- Posts
- 3
- Registration date
- Sunday July 5, 2015
- Status
- Member
- Last seen
- July 6, 2015
Related:
- Excel Challenging - Please Help
- Transfer data from one excel worksheet to another automatically - Guide
- How to change date format in excel - Guide
- Excel @ in formula ✓ - Forum - Excel
- How to change author name in excel - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Forum - Excel
2 replies
Mazzaropi
Jul 5, 2015 at 12:25 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Jul 5, 2015 at 12:25 PM
gutoazuk, Good afternoon.
Please could you enlighten us some details of your spreadsheets?
The spreadsheet 3 you are showing is the actual result you expect to get according to the image of the other two spreadsheets?
What does each column in the spreadsheet 3?
Why, "lilik" appears in three columns and only appears in two rows in the spreadsheet 3?
Surely people will appear to help you.
Just it is clear the real need.
Have a nice Sunday.
Please could you enlighten us some details of your spreadsheets?
The spreadsheet 3 you are showing is the actual result you expect to get according to the image of the other two spreadsheets?
What does each column in the spreadsheet 3?
Why, "lilik" appears in three columns and only appears in two rows in the spreadsheet 3?
Surely people will appear to help you.
Just it is clear the real need.
Have a nice Sunday.
vcoolio
Jul 6, 2015 at 02:25 AM
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
Jul 6, 2015 at 02:25 AM
Hello Gutoazuk,
I'm sure that Mazzaropi has an e-mail address and yes you are practically fellow countrymen but please keep any posts in relation to your thread on this forum and refrain from resolving your query by e-mail or PM.
Please bear in mind that this is a public forum available to anyone who comes here looking for a solution to a query that may be similar to yours. It is a simple case of help one, help all. All posts and resolutions need to be displayed on the Forum for all to see, from start to finish. Any solution that may be found for your query will remain here indefinitely for others to access.
Please familiarise yourself with the CCM Charter (click on Charter at the bottom of the page).
My apologies for intruding.
Thank you and we trust that you understand.
Kind regards,
vcoolio.
(Moderator)
I'm sure that Mazzaropi has an e-mail address and yes you are practically fellow countrymen but please keep any posts in relation to your thread on this forum and refrain from resolving your query by e-mail or PM.
Please bear in mind that this is a public forum available to anyone who comes here looking for a solution to a query that may be similar to yours. It is a simple case of help one, help all. All posts and resolutions need to be displayed on the Forum for all to see, from start to finish. Any solution that may be found for your query will remain here indefinitely for others to access.
Please familiarise yourself with the CCM Charter (click on Charter at the bottom of the page).
My apologies for intruding.
Thank you and we trust that you understand.
Kind regards,
vcoolio.
(Moderator)
gutoazuk
Jul 6, 2015 at 06:34 AM
- Posts
- 3
- Registration date
- Sunday July 5, 2015
- Status
- Member
- Last seen
- July 6, 2015
Jul 6, 2015 at 06:34 AM
Thank you and accept my apologies.
Jul 5, 2015 at 06:28 PM
Thank you for your prompt response.
So, yes. The Spreadsheet 3 is the results from the other 2.
On spreadsheet 1 You read the Number of the Waiter and his name. Eg.(401-LILIK, 402-BRATA, 403,IRWAN) which actually "served" the respective Room/Cabin.
As you see, on DAY 1, IRWAN served Room 105 , LILIK Rooms 107&108, BRATA Room 110..... and on and on.....
On Spreadsheet 2 You See the "Rating" the Guest returned, between 0 & 4....
So, with this information on Spreadsheet 1 & 2, I need it to return to the respective Waiter on Spreadsheet 3 accordingly.
Hope it helps to understand better.
PS> Caso tenha algum e-mail em que possa se comunicar, ficaria agradecido. Vejo q somos quase conterraneos. =)
Thanks a lot!