the value as 2'-6".... your formule should be as below to obtain the desired reuslt...=(LEFT(A1,FIND("'",A1,1)-1))&(MID(A1,FIND("-",A1,1)+1,(FIND("""",A1,1)-(FIND("-",A1,1)+1)))
calulate % what formula should I use to find out what the % is for the number of days in the year. eg 365 days in the year but you only want to account for 212 what % is it? You should be able to find
...a colon instead of the operand between the numbers. Thanks again. Hello, You can use a colon to find a function over a group of cells. For example "=AVERAGE(D1:D10)" would find the average of the ...
Question about Microsoft Excel Computers & Internet
...be viewing a report showing you exactly what you were looking for. Regards, Joe Open:=SUM(IFERROR(FIND("Open",A4:A8)/FIND("Open",A4:A8),0)) then press CTRL+SHIFT+ENTERClosed:=counta(A4:A8) ...
...to the Excel 2007. Has anyone experienced with it? If so What are your thoughts and where can I find examples and tutorials? 10x. D. I haven't had any direct experience with data mining as of
...Excel functions for Lookup tables. The purpose of Lookup tables is to bring a value to the table, find the closest (or exact) match, and then return another value. An example is the federal income ...
there are figures in the Z category. =SUMIF($M$4:$M$41,"=Z",$N$4:$N$41) To deal with this I usually find & replace the Z with something else but I am sure there is a simple solution that I am missing!
Question about Microsoft Excel Computers & Internet
Hi, how do I find the 1st 2 letters in a cell and reference it to another. ie A1: 0209JJP001. I thus want to find "02" which is Feb (this would be a vlookup I assume). Therefore the 1st 2 letters ...
670 questions posted
Usually answered in minutes!
43 Questions
22 Questions
12 Questions
2 Questions