Search results for query: *

Team, I was wondering if anyone know how to insert a song into a powerpoint presentation so that it will loop throughout the presentation rather than being linked to one slide. The goal is to link music into the presentation so that it will play while the presenter is talking and not be...

Team, Is there any way to eliminate leading and trailing white space in all of the cells on a worksheet? Of course, I don't want to get rid of spaces that are insid the text, just the leading and trailing space that came over when I did some copying and pasting. Thanks for any ideas you may...

Team, I have an Excel workbook that is used to generate a seating chart that displays relevant data by code. Currently, the way that it works is that I copy and paste the data from another workbook, then I do a past special with values to eleimate formulas, and then run a coversion macro that...

Team, I have a worksheet full of formulas that reference other sheets in the workbook, and I was going to have to delete and recreate some of other worksheets. So, I did a find and replace all to replace = with '= which made ever formula into a string. After fixing the other worksheets I went...

Team, Is there a way to add an UNLESS or AND clause to a countif. For example: Let's say you have two columns, one has group assignment and the other has a break time. I want to either count everyone whose break time is "X" and is a member of group "A", or everyone whose...

Team, Does anyone know of a way to round off time. In other words, 8:20 would round down to 8:15, 8:25 would round up to 8:30, etc. I know that you can use the round function to round numbers to whatever number of places you care to go, but I cannot get it to work with time. Any ideas...

Team, Is there a way to use the countif function and refence another cell. In other words, to ask EXCEL to count all of the cells in a range whose value is less than or equal to the number in cell B4. For some reason, I can only get it countif to work if I specify the value in the condition...

Team, Is there any way to protect a column of data so that it cannot be overwritten and still allow that column to be used as autofilter criteria? CP

Hey Guys, I am looking at trying to create team lists and pull data from a master Spreadsheet. For Example, I could have: Name Lead Bob Sam Frank Sally Henry Sally John Sam Sue Sally Betty Sam Then on another worksheet, I will...

I am working on a seating plan where I could potentially have as many as two people per seat (1 in the AM and 1 in the PM). I have a data sheet that has colunms for each associate, the seat they sit in, and the shift number that they are on. Then, I have two cells next to each seat number. My...