charlie

Hi Everyone. So I have data (say 500 rows). The data is broken up by persons, and what I want excel to do is ultimately grab a random sample of rows from each person (Let's say 5) and that the samples for each person must be at least two away from the previous one. In the real world there will...

Hello Friends, I need a formula for conditional format for below Sample DATA manually entered A ....B 414 John 420 Christian 421 Christian 414 Mike 456 Charlie 465 Charlie 456 John A ....B 414 Mike (414 contains Mike so the cell should remain same) 414 Charlie (414 does not...

Hi how do I change the formula below to search for multiple matches ie column B3 = "ALPHA / BRAVO / CHARLIE" A3 = ALPHA A4 = BRAVO A5 = CHARLIE A6 = DELTA A7 = ECHO A3 / A4 / A5 need to be flagged "a" A6 / A7 need to be flagged "b" if(COUNTIF(A:A,B3)>0,"a","b")

Hi Trying to find a simple solution to this problem, I have a table of data with only columns A,B & C, all columns have data that go on for ever. Column B should always have the same data in the same order. The problem is some data from column B is missing and I would like to know if I can...

My data exists in the following format and I've been asked to summarize it for the sales team. <tbody> 0.25 Austria Alpha 0.50 Austria Alpha 0.75 Austria Alpha 1.00 Austria Bravo 2.00 Austria Bravo 3.00 Austria Alpha 4.00 Austria Charlie 5.00 Austria Charlie 6.00 Austria Bravo...

I am very rusty on VBA and need some help! I need to delete rows within a range (rows 6 to 85) if the value in Column A does not equal B2. I have pasted some example data below <colgroup><col><col><col><col></colgroup><tbody> A B C 1 Currency GBP 2 Employee Charlie 3 4...

I'm sorry, I am not very sharp with Excel. I tried watching vids on magic tricks #690 and #759 but didn't quite get to what I wanted to do. Can someone help me figure out a formula to accomplish task? I am tracking competition scores over several weeks for a list of teams. The team list grows...

Hello, I would like to know if I have data file in a specific folder named ="Folder A" which will be residing on my desktop at all times, would I be able to retrieve data from the last created file type = ".txt" from it. Can I do it via VBA scripting of some sort? The data in the .txt file may...

Hi, I have multiple sheet in given workbook. Each sheet filled with Column A:E with same number of rows. I would like to combine all these sheets into one sheet and highlight the row for the column header named as "Order" with "Yes" option. Sheet1 <colgroup><col...

<tbody> A B C D F G H 1 X X X 2 ALPHA BRAVO CHARLIE DELTA ECHO 3 4.23 4.20 5.45 6.00 4.23 4.23 ECHO 4 4.88 4.92 4.92 0.00 4.99 4.92 CHARLIE 5 5.58 4.88 6.23 6.23 5.58 5.58 ECHO 6 4.72 4.72 4.72 4.40 4.88 4.72 CHARLIE </tbody> This bit works......G3 is the smallest value found...

Hello: I have a question about adding up the number of employees on duty (column F - #staff ; see below) at particular times (column E - time) based on start and end times of staff shifts in column B and C, respectively. The data in columns B, C, and E are in the 6:00:00 AM format For...