G ganesan New Member Apr 3, 2017 #1 Hi i have making the foumula of = max (c5,e5,g5,h5, o5) in this i need any cell is blank my result show blank how it will make can pls help to me
Hi i have making the foumula of = max (c5,e5,g5,h5, o5) in this i need any cell is blank my result show blank how it will make can pls help to me
B bosco_yip Excel Ninja Apr 3, 2017 #2 Try, =IF(COUNT(C5,E5,G5,H5,O5)=5,MAX(C5,E5,G5,H5,O5),"") Regards
G ganesan New Member Apr 3, 2017 #3 hit thank for your reply .But this formula taken up the text for example c5= 05/03, E5 = NA , G5= 05/03 H5= 06/03, O5= 07/03. In this result shown blank. Because it takes text also consider the BLANK. i Need without text only blank cells Attachments blank cell .xlsx 9.8 KB · Views: 6
hit thank for your reply .But this formula taken up the text for example c5= 05/03, E5 = NA , G5= 05/03 H5= 06/03, O5= 07/03. In this result shown blank. Because it takes text also consider the BLANK. i Need without text only blank cells
G ganesan New Member Apr 11, 2017 #6 hi i have earlier post this post but i did not get proper answer can any one help to me in excel i have cell A1= 05/03/17 ; B1= NA: C1= 06/03/17;D1=07/03/17 ;E1= APPLICBLE ; F1 = blank IN this i need max value if any blank value in cell result shown blank only in another case A1= 05/03/17 ; B1= NA: C1= 06/03/17;D1=07/03/17 ;E1= APPLICBLE ; F1 = 06/0317 in this i need max value i need one formula for both conditions are fulfil the result
hi i have earlier post this post but i did not get proper answer can any one help to me in excel i have cell A1= 05/03/17 ; B1= NA: C1= 06/03/17;D1=07/03/17 ;E1= APPLICBLE ; F1 = blank IN this i need max value if any blank value in cell result shown blank only in another case A1= 05/03/17 ; B1= NA: C1= 06/03/17;D1=07/03/17 ;E1= APPLICBLE ; F1 = 06/0317 in this i need max value i need one formula for both conditions are fulfil the result
