extent

hello i have this formula =IFERROR(IF($BQ$24=13,IF($BL$26=0,"yes","no")&TEXT($BL$26/BL$26,),"NO"),"yes") i want the formula to know the following because it works to an extent if BL26 = 0 then "NO" if BQ24 = 13 then "YES" thank you

in my work sheet i want to get the last 5 cells of a column and display them in 5 other cells. i used the formula below and dragged it down 5 to show the last 5 cells and it worked to an extent but if the last 5 cells are all the same it messes up and doesnt show the last 5 cells...

Hi guys, I have a named table ACR_tbl, I would like to count all the times #N/A appear in the table. If the number is greater than 0 I would like to pull up a MsgBox as a warning. At the moment I am doing this (to an extent with COUNTIF(ACR_tbl,NA()) ), is there a simple way to do it via VBA?

I want require format how to generate the multiple rows using unique data in specific row in word through mail merge or any other format.pls help me Exp: No. Name. Extent 1. Raj. 2.09 1. Raj. 3.12 2. Msh. 1.01 Return No. 1 Name : Raj Extent : 2.09, 3.12