Recent content by Andy Teal

Hello Experts, I'm working with vibration sensor data in Excel, and I've got a set of 1808 values representing samples from one shaft rotation. I'm not an Excel or stats expert, but I've heard about Autocorrelation, which should give values between +1 and -1. I want to use Autocorrelation to...

Yes, we might need to check every possibility. But will it take too long to run the code? And, thanks everyone for your helpful suggestions.

I agree and apologize for the misunderstanding. The given data is supposed to be an example. My main data, however, meets the criteria once. Is it possible to find out the data in A1:A10 that sums up the criteria in C3 with Excel functions or formulas?

It is not working as expected. It could not figure out what to filter that sums up the criteria. Do I need to modify the code?

Hello, I have been on this my whole day. Still could not figure out a way. I need to lookup some values from a list for instance: A2:A10 based on the value of B2. The value of B2 must be the sum total of the filtered values. In the below example, I need to filter out the data whose sum total...

Hello, Need some assistance for the following questions. Q1: example table below, what I need to do is count the number of 'yes' total, except the first section, which is yes if any (so max 1). Red yes Blue yes Green no Banana no Apple no Orange yes triangle yes square no circle no so for...

URGENT!!! Hello All. I need to be able to add a number to a cell and then have the following format be automatically filled in. The only other option I would have is to type it all in on all 1300 rows or copy and past and change the number on all 1300 rows which both do not sound like fun at...

@Gasman I edited the post trying to add the code tags. Is this what you actually meant? Thank you.

I am a new learner/novice on VBA. The following VBA code from this forum works great to copy unprotected rows/cells to paste as image into body of the email. Thank you. I want copy and paste selected multiples rows (cells) into body of the email as shown below. e.g. from practice work book, i...

@GaP42, great work so far. I changed the number 1 hole scores to display two par 4's. No score was lower. The report/the data pointed to 2 skins on the hole that made with a score par 4. That change should have reported 0; no award on this hole. Under that situation. Remember; when there are...

Dear @GaP42, yes, you have it exactly. And yes, I would like for you to create it. I am attaching the file that will include the par score per hole. The data file now incorporated course par per hole row 1. And to have it to automatically generate a report displaying the winners without null...

@GaP42, this is progress. Thanks a lot. The traditional "skin" in golf is not what I am seeking. Programs already exist for that. The tools that you provided are eye opening areas for me. But, I have the need to automate results for the following. The report/results would consider: "TWO LOW...

Hello June, I am not an expert in golf too. Thanks to @The_Doc_Man, now I understand more about golf. Can you give me some idea on how to build that report? I would be really really grateful. Thanks.

i want first and last value(time) of a given date in two different columns im able to get the first value through vlookup with a helper column, but have trouble with the last value Result Helper Column Name Date Time in/Out First Value Last Value Young|45068 Young 22/05/2023...

Help! I have golf data (scores hole-by-hole); but I need to use it. I seek to create a skins report by selecting data based on criteria hole-by-hole. The skins report would consider: 1 par per hole, if there are no lower scores on that hole. Or... Up to 2 birdies per hole; if there are no lower...