• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Compare different koloms

P

Pofski

Member
Hi,


The situation is as follows.

In sheet one, you have a huge spreadsheet containing all the data. Amongst that is kolom D and J which are important for this question.

In sheet two, you have an other spreadsheet, with koloms B and E containing the same type of data as the ones in sheet one.


Now, sheet two should have a kolom that says yes/no if in that row kolom B and E correspond with a row on sheet 1.


Now the first row in each sheet does not contain unique numbers, nor does the second row. But the combination should always be unique.


I have gone through the chandoo tutorials about using the list comparisons, but they use singular koloms, and i have no idea how to implement it for multiple koloms.


Also, the data in all the koloms are text.


Thank you in advance
 
Pofski


Can you possibly post a sample file of your data with a sample of what the answer should be ?

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
https://docs.google.com/file/d/0B0naOkYo4pCmUHZiSktGZHdFR28/edit?usp=sharing


Explanation is as follows:


Data is imported into the Main Data tab. This happens on a regular base (weekly)

When the data is imported, a comparison of column equipment ID and Service is made between the main data and Planned work tabs.

The combinations of Equipment ID and Service is always unique. But each can be multiple times in their respective columns.


If there is a data completed in column "date afgewerkt" in tab Main Data, it moves the same row in Planned work to tab Executed work.


What is supposed to happen is actually simpler then the way that i'm trying to explain it.

I just suck at explaining stuff :/


If there are any questions, i'll try to answer them as plain as possible.


Thank you in advance
 
Hi Pofski.....I cant stop laughing for the sentence "I just suck at explaning stuff.."


Looking at the sheets, its seems like you have used some pivots and show.selection to view your required data.


I think this is the best option to use, we can concatenate the Equip ID and service in a new helper coloumn and create a pivot based on this....


Might be Ninja's would be able to help better....
 
I think, Indian, that if we use your method, that the only thing i need is a way to copy data from a row where a date is filled in to the next tab.


So in other words, when a date is filled in the main tab, then it would be added to a table in Executed Work.

And if the date is empty, then it is added to a table in Planned Work.


Anybody have an idea?


Thanks
 
You must log in or register to reply here.
Back
Top