Hello. Does excel have missing data techniques? For example, turning a data set into a table that shows the count for each unique combo of missing data. E.g, 1000 complete, 45 miss rows 3 and 4 the rest are complete, etc etc.
Hello. Does excel have missing data techniques? For example, turning a data set into a table that shows the count for each unique combo of missing data. E.g, 1000 complete, 45 miss rows 3 and 4 the rest are complete, etc etc.
I need a better definition of what you mean by "missing data." A sample spreadsheet would really help. I'm fairly certain that some sort of combination of concatenation, MATCH() and maybe even ROW() can achieve what you want.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Im puzzled as to how you would count missing data?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yeah - I missed that one
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks