Excel Magic Trick 862: Count Numbers In Column, But Only If Number Is Not Repeated In Row

[blackultra2000]

Hi. Where is excel basic for 2010. I am having a hard time finding the beginning of excel 2010.

[ExcelIsFun]

@blackultra2000 , watch this auto play video that shows how to get to videos and files for Excel Basics:

youtube [dot] com/excelisfun

[iGreek88]

@ExcellsFun is there a way to create a database of info in excel that can be used for future reference in separate excel window. I want to make a database with names and room numbers. in a separate excel workbook i want to be have room numbers pop up just by typing in the name. is this even possible?

[ExcelIsFun]

@iGreek88 , try the Data Validation and VLOOKUP tricks in this video:

Excel Magic Trick 334: VLOOKUP & Data Validation for Invoice

[krn14242]

Thanks Mike.

[ExcelIsFun]

@krn14242 , you are welcome!

[MsJoanbabe]

You are so awesome! thanks for sharing your knowledge =)

[ExcelIsFun]

@MsJoanbabe , I am glad to help!

[Cosme422]

useful, thanks!

[ExcelIsFun]

@Cosme422 , I am glad that you like it!