Counting text in a range is easy. For example, if you would like count how many times “text” is in a specified range (named data), you can write something like this: =COUNTIF(data,”*text*”) This formula will give you the count of all the cells where Excel found “text” at any place. But let’s say you want […]
Continue readingThis is a new one for me. One good thing working with Excel and Access is the Copy/Paste ease between them. I usually paste data from Excel to Access for these two reasons: Create tables in Access (for small tables) Paste Field names: either in a table or in the import specs form When I […]
Continue readingProblem: When I tried to export a table/query from Access 2007 to Excel 2007, I was getting this annoying error: You selected more records than can be copied onto the Clipboard at one time. Divide the records into two or more groups, and then copy and paste one group at a time. The maximum number […]
Continue readingEver felt the need of creating different sheets based on the distinct values of a column. For example, in your data, you have a column called STATE, and you would like to create a separate sheet for each state with all the data from that state. Here’s your solution then:(Note: you’ll need to add a […]
Continue readingIf you do not wish to enter complex formula in Excel and you already have calculated average, count, and variance for your samples(Tip:use a PivotTable), then you can use these user-defined functions to calculate the t-test stat value and degrees of freedom required to do hypothesis testing. Both the functions provide an optional argument for […]
Continue reading