I would like to ask for some help regarding some EXEL problems.
Example: I want some data from sheet1 E columns to transfer to sheet 2 E columns if the A column contains a number "1". If it doesn't the command will ignore the row and move on.
I tried something like [Sheet 2 C50 cell ] =IF(OR('sheet1'!A50=1),'sheet1'!E50)
It works but for the rows that doesn't contain the number 1 shows the word FALSE. Is it possible for the exel function to just ignore the columns without the number one and just copy the names from the rows with the number 1 on the A column?
I'm making this for a daily attendance report thing.
I'm using Microsoft Office 2007
I apologize for any poor grammar.
Please and thank you.
Auto Transfer of a filtered item to a different sheet.