Search results

:p :awesome:

What's the issue here? you can use simple vlookup or please explain your query.

try below formula and drag =MATCH(A2,INDEX(ROMAN(ROW(INDIRECT("1:3999"))),0),0) * 3999 because in excel Roman function support till 3999 only.

Kindly share the some example.

Little confused, what columns you are referring (in raw data 1 to 10) or just wanted to sum based on Parameter if yes then refer below formula E2 = =SUMPRODUCT((Data!$A$5:$A$15=Sum!$A2)*(Data!$C$5:$L$15)) and drag

Hi Sasuke, Please refer below url for clear pivot table cache http://www.contextures.com/xlPivot04.html

Little confused with your query, can you please upload the desired output

Hi Seansr, Use below formula =IF(SUM(--ISNUMBER(FIND({"\";"/";"*";"?";":";"<";">";"|"},A1)))>0,"INVALID CHAR","") Referenced from http://www.mrexcel.com/forum/excel-questions/66289-warning-about-illegal-characters.html

Change the Data formula with below formula ="("&LEN(D2)-LEN(SUBSTITUTE(D2,",",""))+1&") = "&SUBSTITUTE(D2,",","")

Gajab shrivallabha, This is what I was looking. Thanks

Hi Thomas, See if this helps.

Hi Tom, See if this help.

Hello Tom, It would be great if you can share the desire output

Hi Mohit, You can simply modify range part with INDIRECT =SUM(--(FREQUENCY(IF((J2:J4982=B2)*(K2:K4982=E2),L2:L4982),L2:L4982)>0)) Same for K,L,J like L2:L4982 change with INDIRECT("L2:L"&COUNTA(L2:L71000))

Hi RafaelAngel, Slicer is depend on Pivot table fields, so you can group by / format your filed in pivot table and it will automatically visible in slicer.

Thanks Khalid NGO ,bosco_yip (ExtraOrdinary) and Hui, But, I am looking for Dynamic formula based on table 2. Attaching the sample data with requirement.

Hi Douglas, Try this, this is working fine for me. =HYPERLINK("https://www.google.com/search?q="&SUBSTITUTE(A1," ","+"),"Search Google for "&A1)

Dear All, Is there any way to lookup values which have already in range like 90-95, 80-85 so on, without making helper column. Using table one i required bucket value in table two. (I am able to do this using lookup function but using helper column). Please suggest the another way to do this...

Hi Rahul, I think you are talking about Workbooks not worksheet It can be done using by VBA (FileObjectSystem) or command line (CMD)

Great Ramesh, Kumar M B, Hope this is clear now, - I used ROW(65:90) to populate A-Z series, rest very clearly explained by Ramesh

This is awesome bosco_yip, Thanks for sharing "out of the" box stuff God Bless you :)

Mr Kumar, There is many ways to do this, 1) =COUNTA(A2:A31)-COUNTIF(A2:A31,"-") 2) =SUM(COUNTIF(A2:A31,CHAR(ROW(65:90)))) with crtl+shf+enter and many more

You can use pivot table -

Try this =IF(ISTEXT(Y2399),Y12,"") :)

Lets play with Excel :)