http://forum.lowyat.net/ Sun, 21 Jun 2026 18:01:27 +0800 FeedCreator 1.7.2 http://forum.lowyat.net/topic/2264084 Hi all the Sifus,<br /><br />Recently I was struggled with the following formula,<br /><br />1) =OFFSET(Sheet1&#33;&#036;A&#036;3,0,0,COUNTA(Sheet1&#33;&#036;A:&#036;A)-1,9)<br /><br />2) =OFFSET(Sheet1&#33;&#036;K&#036;2,0,0,COUNTA(Sheet1&#33;&#036;K:&#036;K),5)<br /><br />It is working on the specified excel data but when I try to apply it in other database, it doesnt work anymore.<br />So I think I must figure out what does it mean by the argument in the format, like I know Sheet3&#33;&#036;A&#036;3 is the starting point but I have no idea what does it mean by the others. <br />Should any sifus know what does it mean, please show me so guidance.<br />Thanks<br /><br /> lewvincent Codemasters Tue, 13 Mar 2012 15:06:50 +0800 http://forum.lowyat.net/topic/2228951 Recently I got one little project from my boss. Its all about the filtering the data from a database. I know it can be done via the filtering option in the data column but my intention is built a user form so I can filter it via either text filtering. Anyone can advise or suggest what should I go for?<br />Thanks lewvincent Codemasters Thu, 16 Feb 2012 10:27:52 +0800