cell analysis

I have ~50,000 usernames in Column A on Sheet1. Many of those usernames repeat. On Sheet2, I have the same usernames in Column A, followed by their employee IDs in Column B. But on Sheet2, there are no repeats. I want to copy over the IDs from Sheet2 into the corresponding place in Sheet1...

Hello all, I have a problem that I am trying to solve. I have a table with over 770K rows. These rows contain data about the weather at different times of each day. In the fourth column (Type) there is a mix of AUTO and integers. The integers are supposed to be in the Wind Spd & Dir column...

i am trying to solve a scenario.... A1=332.345 B1=331.658 C1=331.229 D1 should give output as 1 provided Condition1: A1>B1 AND C1<B1 Condition2: Neither of A1, B1 & C1 should be <=0. If any of abv 2 conditions are not met then D1=0. What formula needs to be punched in D1? Thnx in adv.

I'm making a schedule for school. The school website will give me an excel document of all the games and practices put in. I download the list and then paste it into a formatting page that will then link to all the other scheduling formats and needs I have. The time's of the practices come...

Hi, I am looking at the transfering the following code from Excel VBA to Access VBA and was wondering if anybody could help me by telling me which factors I should look out for/ how I should change the code so as to make it functional. What the code does is to take an interval in a set of...

Is there a way to split a numerical value of a single cell into each integer of it's value and list them separately in individual cells? For example: 391 is the value in cell A:1 and I want cells B:1, C:1, and D:1 to read 3,9,1 respectively, so I can derive at 13 in cell E:1: which is the sum of...