-P-Henderson
asked on
Excel Formula
Hi All,
I need Excel to perform a calculation but i do not know how to do it.
Here is the scenario:
I need a formula that will read column B&DIF they are the same value to then check columns C&E IF C&E are the same value, i want that value to be written to Column A.
A B C D E
1 1/1 1501 (green) 1/1 1501 (green)
2 1/3 1501 (green) 1/3 1501 (green)
3 1/5 1501 (green) 1/5 1501 (green)
4 1/6 1501 (green) 1/6 1501 (green)
5 1/7 1501 (green) 1/7 1501 (green)
6 1/8 1504 (green) 1/8 1504 (green)
7 1/11 1504 (green) 1/11 1504 (green)
8 1/13 1501 (green) 1/13 1501 (green)
Hopes this makes sense, Thanks for your help
I need Excel to perform a calculation but i do not know how to do it.
Here is the scenario:
I need a formula that will read column B&DIF they are the same value to then check columns C&E IF C&E are the same value, i want that value to be written to Column A.
A B C D E
1 1/1 1501 (green) 1/1 1501 (green)
2 1/3 1501 (green) 1/3 1501 (green)
3 1/5 1501 (green) 1/5 1501 (green)
4 1/6 1501 (green) 1/6 1501 (green)
5 1/7 1501 (green) 1/7 1501 (green)
6 1/8 1504 (green) 1/8 1504 (green)
7 1/11 1504 (green) 1/11 1504 (green)
8 1/13 1501 (green) 1/13 1501 (green)
Hopes this makes sense, Thanks for your help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mmm seems to me the update of EE is to slow, I can't remember typing for more then 2 minutes, jimy, you did beat me to it...
ASKER
damn you guys are fast !!! thanks to you all
Hi P,
thanks for the assistend solution...
Eric
thanks for the assistend solution...
Eric
ASKER
if i wanted to extend this to include further columns ie... F compared to B and G compared to C...
Basically the overall result is that i need to add data everyday to find out the common average.... so as long as columns B/D/F etc match the results which are C/E/G need to be put into column A as the most prominent result.
So if B/D/F all matches the results from C/E/G results were 1501,1501,1502..... then 1501 would be place in column A as it was produced more times.....! if any of that makes sense
A B C D E F G
1 1/1 1501 (green) 1/1 1501 (green)
2 1/3 1501 (green) 1/3 1501 (green)
3 1/5 1501 (green) 1/5 1501 (green)
4 1/6 1501 (green) 1/6 1501 (green)
5 1/7 1501 (green) 1/7 1501 (green)
6 1/8 1504 (green) 1/8 1504 (green)
7 1/11 1504 (green) 1/11 1504 (green)
8 1/13 1501 (green) 1/13 1501 (green)
Basically the overall result is that i need to add data everyday to find out the common average.... so as long as columns B/D/F etc match the results which are C/E/G need to be put into column A as the most prominent result.
So if B/D/F all matches the results from C/E/G results were 1501,1501,1502..... then 1501 would be place in column A as it was produced more times.....! if any of that makes sense
A B C D E F G
1 1/1 1501 (green) 1/1 1501 (green)
2 1/3 1501 (green) 1/3 1501 (green)
3 1/5 1501 (green) 1/5 1501 (green)
4 1/6 1501 (green) 1/6 1501 (green)
5 1/7 1501 (green) 1/7 1501 (green)
6 1/8 1504 (green) 1/8 1504 (green)
7 1/11 1504 (green) 1/11 1504 (green)
8 1/13 1501 (green) 1/13 1501 (green)
Hi P,
this would be easier to do with a macro..
But you would need a new question for that.
Kind regards
Eric
this would be easier to do with a macro..
But you would need a new question for that.
Kind regards
Eric
ASKER
Ok Thanks,