In my Excel there is a column, say, column A, where all the cells are text string such as company names. My task is to filter all the rows where the cells in column A contain the same company names. However, my problem is the company names was originally entered from different sources therefore for the...

I used conditional IF to write my formulas but when my table increase in size, it became many IF statements in a cell. I tried to replace IF with lookup function but some how I got so many ERR. Can someone write me the formulas to solve my issue? Here is the example: It can be a row or column but let...

i am trying to make an if statement that accomplishes something like, If c1=b1 then d1 = pick a choice from the data validation list(drop down list) that is from e1 to e5. else pick a choice from the data validation list(drop down list) that is from f1 to f5. i am new to running macros in excel. pls...