# cell analysis

1. ### Help identifying whether Sheet1!A* = Sheet2!A* and then populating with Sheet2!C*

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...
2. ### Moving specific cells to the right

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...
3. ### Check a cells value

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.
4. ### Figuring out what contents are in a cell

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...
5. ### Advanced Min-Max in Access

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...
6. ### excel beta 2010

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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back