Search results

Congrats @Debraj ..For sharing the same platform with @NARAYANK991 :) Its an honour for me..

Hi KapardhiSarma! Can you please check with this one too.. =MATCH(0,$A2:$V2,0)-1

Hi Aamir! If your Project Sheet, is like below.. then your formula will work fine.. Data should be sorted A - Z, And only one character should be in Column A..

Hi Sunil, here another approach.. using Ctrl + Shift + Enter =SUM(IF(A2:A22={"F2","F8"},1/COUNTIFS(B2:B22,B2:B22,A2:A22,{"F2","F8"}))) + Point.. If Invoice Number are in AlphaNumeric.. Still it will Work.. - Point.. In case of blank INVOICE #, it will fail.. unlike @Somendra Misra 's...

Hi Bhineet.. Can you please upload a sample file with expected output.. BTW, Conditional Formatting with ICON's, never works with Relative Reference. By seeing your upload, we may able to create some workaround..

Hi getpras.. Pivot table are always used for NUMERICAL data analysis and crunching. In case of crunching with TEXT data, you have to used FORMULA based approach..

Thank you.. I also think, pivot table problem.. Do you want us to do anything.. !!

Hi, Welcome to the forum.. In this specific case, You have to use a helper column, lets say D, in this column use your formula. "=if (B3>C3,B3,C3)", coz, excel need one physical area, to compare Col C, with Col B, BTW. to get the value you are using a UDF, and You can change your UDF, to get...

Hi Lily.. As per your experience.. I guess you have already realized. its working the way you want to.. :( Let me elaborate.. =IF($C2<$D$1,0,MATCH($C2,$D$1:$O$1,1)) As D1 is fixed.. so its doesn't matter.. all other columns in D1:O1 is less than or greater than C2.. So 1st part not so...

Hi Karthik, Just a blind guess. Did you tried.. ActiveWorkbook.RefreshAll Caution: It will refresh all the Data connection also in the sheet.(if you have any.. :))

Hi Prtucale.. Just in case.. if you want to extract the nth word between a specified delimeter.. try this.. =TRIM(MID(SUBSTITUTE($A1,":",REPT(" ",99)),((2-1)*99)+1,99)) where Delimeter is in RED, and nth Word is in BLUE.. Increase this 99, in case of very long word..:)

Hi Shahul.. Let me know, if you need further details.. Sub OpenFile() 'Opens a file called TESTFILE.XLS from same folder as this workbook Dim fPath As String Const fName As String = "Test1.XLSx" fPath = ThisWorkbook.Path & "\" & fName 'Check if file path is legit...

Can you please upload a sample file.. with expected output.. With this small data view, its really hard to decide :(

Pass it to LUKE.. :)

Hi VDS.. Did you tried to drag it.. toward Right side.. :(

Hi Shahul.. Just a lil modification Luke's Code.. :) fPath = ThisWorkbook.Path & "\" & fName

Thanks for the feedback.. :)

Option Compare Text Sub OnlyReportID() Dim sourceRange As Range, CriteriaRange As Range, Output As String Set sourceRange = Range("A1:D1000") ' Set Source Area Set CriteriaRange = Range("G7:H7").CurrentRegion ' Set Criteria Area With sourceRange For I = 2 To...

In C2. Use CSE formula as.. =IF(ISERROR(INDEX($B$2:$B$126,SMALL(IF(ISNUMBER(SEARCH(C$1,$B$2:$B$126)),ROW($B$2:$B$126)-1),ROW(A1)))),"",INDEX($B$2:$B$126,SMALL(IF(ISNUMBER(SEARCH(C$1,$B$2:$B$126)),ROW($B$2:$B$126)-1),ROW(A1))))