Search results

lol man .... if that's the lowest point of my day I'll be more than pleased with how life is going. Though, to get on grammar/spelling, the use of "an" before US is incorrect ...... so there is that. ;) :D

.......... I slept on it and am feeling a little foolish today. I just convert each field to a whole number. Add respective group together then divide total by 29. Autopopulate down and viola. :)

Hui, Thank you for the reply. The question I have though, is - how do I go about this for all the questions in the survey, as the percentages vary greatly throughout the survey. Is there a way to write a formula that I can autopopulate right down the spreadsheet? Or is the weight in itself...

Here is the question. We had a survey at work. The creators of the survey didn't do a good job and accidentally created 2 separate work areas even though we have 1. So I need to figure out how to combine the percentages based on the weight of the two sections. Group 1 - 13 responders...

eh - nevermind. I just used an IF/AND function to capture the data - creating a "1" for matching results, filtered that down and deleted. Still too many steps for my liking but it works.

Fred - When you have ~1350 unique names it isn't that simple. Especially with common last names (i.e. "Smith"). Also, this still raises the issue of going through every one individually which I don't have time for and don't want to repeat each time this spreadsheet needs to be distributed.

I have have ~1500 rows of data. In two columns (in this instance it is "C" & "D") you find the last name and first name, respectively. I know there are individuals that have multiple entries and would like to delete them out. I don't want to create a conditional format to highlight a single...

Thank you all for the help. As a FYI - using the [-abs] code gives an error as it's a circular reference. I played around with it and got it to work but the first time I copy/pasted it I ended up having to kill the computer as it wouldn't allow me out of the VBA box. It was crazy. I'm...

NARA... Thank you for the post. I don't know VBA yet so don't know how to incorporate that into the Code area for my worksheet. Does it matter what the name of my worksheet is (in reference to your specific code)? IE - my worksheet is named "MacroForm". Sorry for being such a rook

good evening all - looking for a little help here. I've had a long day and my brain is mush. I just can't get my brain to really function on any level right now. Worksheet has four cells: B1 - date B2 - <data validation> two choices (Depoist/Withdrawl) B3 - <data...

John - Thank you for your time and sharing your experience (as well as the youtube link). I will let this consume me if I'm not careful but it will be a good opportunity to learn some new tools. Once I complete it, if you don't mind, I'd like to share with you to do some QC checks. Of course...

My wife works for a small company that doesn't believe in using any software that has been built in the last 50 years. They use an excel spreadsheet with ~30/40 employees that work in 6-8 different locations. Most of them stay in the same location but there are a few who float locations and...

Luke M - thank you for the link. That helped a lot. Fred - you are correct with the one on one relationship. Only one facility in any one city. The information was forwarded to me and why they want them split, I don't know. In the end my main focus is them gathering total numbers of...

Good afternoon everyone. First time post here. Have been perusing this site for a couple of weeks and am amazed at the wealth of information. So glad I came across it. I have a question that I can't figure out. I'm an intermediate Excel user. Can get around, use a few different functions...