hi expert...
i am looking for excel formula or trick, how to make display certainty text dynamically based on last data ...
for detail information, please see my workbook attached...
any help, will be appreciated ...(please, not macro)..
john m
hi expert...
i am looking for excel formula or trick, how to make display certainty text dynamically based on last data ...
for detail information, please see my workbook attached...
any help, will be appreciated ...(please, not macro)..
john m
H John,
Unfortunately, the data you provided doesn't support your request.
1. You can't have "Robert Thang" appear if doesn't exist anywhere on the spreadsheet.
2. # 3564 is also nowhere to be found.
I order for us wright a formula we need to know where this data exists on the spreadsheet.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
HI Jhon Mustofa ,
If there is no blank on column B, try this formula
=+INDEX(B:B,COUNTA(B:B))
Regards
Okay, so you're going to be manually entering data (or pasting) into A,B and C and then one row past the last set of data you want your "sincerely" phrase?
The only way I can think to do this without macros would be to prepopulate Column C with a formula that you would be writing over.
In B7 copied down
=IF(OR(B6={"","#3564"}),"",IF(B6="Robert Thang", "#3564",IF(B6="Sincerely,","Robert Thang", IF(ISTEXT(B6), "Sincerely,",""))))
See attachment
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
thank guys..
i am confused for explain it but here new sample upload for illustration what i want it...
i want text "Sincerely,Robert Thang,#3564" always display based on selected cell in K3(drop list selected)/adjustable,like text "total" (dynamic display)
sorry, text ""Sincerely,Robert Thang,#3564" not in single row (see # 1 OP)
IN your example, with "e" chosen in K3, what cells do you want "Sincerely, Robert Thang #3564" in?
hi ChemistB, "Sincerely" in Column K, and 3 cells under "Sincerely" then "Robert Thang" 1 cell under "Robert Thang", so will be ;
last data shown
Sincerely,
blank cell
blank cell
blank cell
Robert Thang
#3564
once again, keep based on last data above and with "e" chosen in K3
In K8 as an array, copied all the way down
=IF(K7="total","Sincerely", IF(OR(K4="Total", K5="Total", K6="Total"),"", IF(K3="Total","Robert Thang", IF(K2="Total", "#3564",IF(COUNTIF($K$5:K7,"total")>0,"",IF(AND($K$5="date",$K7=""),"total",IFERROR(INDEX(A$6:A$1002,SMALL(IF($B$6:$B$1002=$K$3,ROW($B$6:$B$1002)-ROW($B$6)+1),ROWS($B$6:B8))),"")))))))
See attachment
hi, chemistB, thank you very much...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks