sara

Hi Experts, I need quick help. I can't share my real data however I have made up this dummy data. My real data has the similar pattern and have more than 10,000 rows. Thanks in advance for your help. Here is the problem. I have 2 sheets. SheetA and SheetB in the same workbook. SheetA...

Dear Sir or Madam: My name is Robert, and I am very proud of myself as I am gaining more knowledge about creating complex Excel formulas to help me become a better middle school teacher. I am extremely close to creating a formula that will return a "2" provided a student's answer consists of...

Hello...I am a middle school math teacher who is trying to create a SEARCH formula that will require more than a one-word answer, and I also need the formula to return a '2' for true and a '0' for false. For example, the answer to a particular word problem is 'Sara', and students have to justify...

<tbody> robert alan josh sara concatenate w/header 3 4 5 robert (3) & alan (4) & sara (5) 2 8 alan (2) & josh (8) 1 6 alan (1) & sara (6) </tbody> let me see if i can explain this clearly. i am trying to come up with a formula for column E that if the cells in that row's range are...