Search results

another way =MID(A1,FIND("*",SUBSTITUTE(A1,"_","*",2))+1,4)

hi Faseeh, i already added helper column using offset and its working fine, i'm just asking that question since i'm curious if maybe there are new tips/tricks regarding pivot thanks

hi guys, happy new year to all of you, seems a bit late but nevermind :), i want to ask regarding pivot chart...can we get only the latest 4 cell in it? or we need to make help table then do index or offset there to get latest 4 cell? example you have period there from jan, feb, mar...

hi, this is not good but at least you can see something. A1 : Target Invoice Value 1. pivot the invoice, then sort from largest to smallest (B1 : C10 for example) 2. in D1 =floor($A$1/B1,1) then drag down 3. in E1 = = B1*D1 then drag down 4. in F1 = $A$1-E1 then drag down at least you...

Hi, right click on the horizontal axis, then choose format axis, then search for Base.. change Years to Date then it will reflect the date

Hi, put all the holiday list date from A1 : A10 then press CTRL+F3, create new name range... you can name it as "holiday" for example (without quote) then in the refers to : =Sheet1!$A$1:$A$10 then do networkdays("1/10/2012",TODAY(),[holiday]) and it will work after you type ,today()...

hi, maybe this could help http://csvdiff.sourceforge.net/

hi, so you need formula in G238:G239 then just drag it to P238:P239 right? i will explain how i do this if i were you, - you need to copy E6 (Product1) to E7 then just color the font to white, do this for all empty column, just copy the Product above - do this as well in E239 and E242...

thanks all guys, dont know if i can understand it but it is better to have something than nothing :)

hi guys, i'm curious about array formula, do you have any source/tutorial that i can read about it? i dont really like it much since if i accidentally click on that cell.. the array is gone, and it ruin the formula, but i think it will be useful if i know the basic of array then maybe i can...

hi guys, i'm just curious if we can make a line automatically from graph, not the line graph btw.. here is the picture for it http://speedy.sh/wyg6f/Untitled.jpg everytime i update my chart data once / week, i need to go to that graph to adjust the red line + edit the date so people know...

hi Luke, thanks for the tweak, it worked :)

hi All, i got this macro from chandoo posting about how to click on cell then will trigger pivot table to filter. question is.. can i make the activecell to range example b5:b10? so when i click another cell it wont trigger the macro. nowdays i have to protect sheets and allow only range...

hi, hope this is what you want, the yellow color is helping column for calculation. http://speedy.sh/SfH9j/Copy-of-sample-3.xlsx to download : click on the link above then click on your file name.xls

hi, i think you didnt try that formula :), if you try then you will understand. basically lookup will try to lookup value as you wanted, but if it cannot find the lookup value then it will automatically search the lowest value. a1:a5 = 2, 5, 6, 8, 10 b1: 9 c1: =lookup(b1,a1:a5)...

hi, you can do =lookup(today(),A2:E2) or if you put =today() in A1 then you can do =lookup(A1,A2:E2)

thanks faseeh, i have some idea based on your workout, 1. i will try to use your sumproduct formula in column I 2. the 2 month to compare will be based on pivot table column V and W then i will put 2 active box + macro to control pivot table column V and W (so we dont need to choose...

Hi All, thanks for trying, right now i do it manually but it is ok now :) i make 1 pivot table only consist of 2 months that i need to compare..then i will make if(and(a1=1,b1=1),"yes","no") yes meaning : item exist in both month then in the actual data table i will do index & match then...

i think it cannot be done using formula, you will need to have 2 box then input manually month name into that box.. then press button so macro will do the vlookup against that 2 months then we can just refresh pivot table and using the slicer is there anyone can do that kind of macro? thanks...

hi guys, need a huge favor here, i have some item in each month, the item is just same item with selling quantity different each month. the different is sometimes we received those item and sometimes we didnt received. when i put all item in table then do the pivot table chart.. we can...

hi, i turn off animation when scroll/moving from one cell to another is : - click start, right click on computer choose properties - go to advanced systems setting - choose Advanced, click settings on performance - then on Visual Effects click Custom then unclick Animate controls and...

hi Hui, thanks for the advice, i try that and make the cell range as $absolute, it is working like i said if you choose type 3 in pivot table, the % is correct.. but if you dont choose anything ...then it shows wrong figure. i think things like this cannot be solve using excel since the...

Hi All, i have one problem how to sum multiple criteria then divided with the accumulate value, i try to use sumproduct or sumifs but still it wont work when related with accumulate. i attached work sample here. column H = is the column i need to work with now if i pivot all data.. it...

thanks so much chandoo, didnt saw it since it is in the right hand side and not in the slicer settings

hi all, is there any trick to make the slicer not showing in vertical but horizontal? let say you have 20 items it will show like X X X X can we make it look like XXX XXX XXX thanks