Download from: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Create:
1. Helper column using AND function and the "not comparative operator" to check to see if numbers in row are all not the same
2. Helper column using OR and NOT function and the "equal comparative operator" to check to see if numbers in row are all not the same
3. COUNTIFS function with Mixed Cell References to count numbers in column, but only if number is not repeated in row
4. SUMPRODUCT function with Mixed Cell References to count numbers in column, but only if number is not repeated in row
5. SUMPRODUCT formula with four arrays that count numbers in column when when number is not repeated in row
Hi. Where is excel basic for 2010. I am having a hard time finding the beginning of excel 2010.
blackultra2000 3 weeks ago
@blackultra2000 , watch this auto play video that shows how to get to videos and files for Excel Basics:
youtube [dot] com/excelisfun
ExcelIsFun 3 weeks ago
@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?
iGreek88 4 weeks ago
@iGreek88 , try the Data Validation and VLOOKUP tricks in this video:
Excel Magic Trick 334: VLOOKUP & Data Validation for Invoice
ExcelIsFun 3 weeks ago
You are so awesome! thanks for sharing your knowledge =)
MsJoanbabe 1 month ago
@MsJoanbabe , I am glad to help!
ExcelIsFun 1 month ago