Search results

wow, it worked .. thanks Ken !

hi Smallman, thanks for helping and yes it's not working since i need the transparent (this is the most difficult things i believe), will have to think another way of doing it.. thanks2

Hi All, i really need help on this one since i cannot make it on recorder, and through searching i found several others threat here but i cannot use it in my case. all i want is actually simple i think.. something like below :) if Sheets("sheet2").Range("A1").Value = 1 then color...

nevermind luke, i got it, thanks :)

hi Luke, thanks it is working now, one more question.. if i need to cut those row if they find "old" in it, and delete the row up, what should i do?

hi Luke, thanks for replying, and I got error on below code "the command cannot be use in multiple selection" could it be because you selected 3 sheet as an array before? how if we only want to copy from sheet1 for example? 'Check if there were any cells If Not copyRange Is Nothing Then...

Hi there, i have this code below that works just fine by using autofilter.selection, problem is when it filter and not find the word "old", it still copy first non blank cell there. can we add like if not find "old" in auto filter then just skip to next ? thanks all for the help Sub rec()...

hi all, need some advice here on how to make a formula to pick a specific date from same date, i have 3 columns A (Date), B (Name) and C (status : success or fail), A2:A10 = date, B2:B10 = Name and C2:C10 = status all i want is example A2 : 1 jan 2014, A3:1 jan 2014 B2 : a, B3 : a C2 : fail...

hi Debra & Somendra, thanks for the solution, it worked :)

Hi All, can anyone advice how to find latest date as per my example? this is basically is almost the same with find 2nd, 3rd value using lookup in chandoo example but i need to find more answer especially if not using helper column. i attached file for example and i already has the solution of...

hi all, i think i found a trick by insert text box then point the text box to a cell, in the cell just put a formula to retrieve latest number. ;)

hi all, i have a question regarding data label, lets just say we have something to be input as line chart in every week and we want to show the latest week value in the line chart, normally what i do is i select the latest dot in line chart and click add data label, then delete the previous...

hi Narayan, thanks for the answer, its solved my problem regards,

Hi All, just got this problem today, i have a list from A1:A20 contain a number from 1 to 1000, but some of the number ended with ? like 10?, 109? 1? etc when i filter them and put ? in the filter its not working, and seems like ctrl+h and replace ? with blank also not working. do you have...

Hi, i think this is the answer http://www.yo*tube.com/watch?v=2vVYblsBCAI br/koi

Hi Debraj, thanks for the answer and i've seen that topic before only not really into powerpivot so i posted question here to search for another option, one question though.. if i setup the slicer using power pivot, can it still working for people using excel 2010 and they dont have power...

Hi All, I'm using excel 2013 and want to ask if we can use slicer to show top 10 or bottom 10 value filtered. thanks

Hi, you can try IFERROR(IF(VLOOKUP(E2,staffdata!B:K,10,FALSE),4,""),"")

hi, i think simple vlookup like =IFERROR(VLOOKUP($C5,Table1,2,0),"") in D5, and =IFERROR(VLOOKUP($C5,Table1,3,0),"") in E5 will do it

excel 2013

hi, maybe it is because center no is not unique number, just add 1 helper column combine center no & id no and dont forget to add $ sign since it is in 1 workbook.

hi, what version of excel are you using? if you're using 2013. go for this step 1.add the data into pivot table, but before click ok, please make sure you click "Add to Data Model" then click OK 2. put everything in ROWS, and in Value you put Count of Distinct 3. now right click on count...

let say your example start from A1, so in B1 put this =MID(A1,FIND("*",SUBSTITUTE(A1," ","*",2))+2,1)+0 and copy down then you will see #value and some numbers. now you need to applied filter on column A and B, select B and choose only #values then press F5 > specials, select visible...

if your word to find always has "-" and always consist of 3 words, you can try below =MID(A15,FIND("-",A15,1)-4,4)

hi, maybe like this ? http://speedy.sh/YaZcb/Copy-of-sampledata.xlsx using some helper column + pivot table