Search results

Your method works for me to return Bill Kay in cells D4, D5 respectively. Is this what you are trying to achieve?

Then following formula shall work. ="AB"&MID(A2,7,2)&" "&MID(A2,IF(MID(A2,5,2)="AB",9,5),2)&" "&MID(A2,1,4)

So does it mean it will always be Text AB or there is any other possibility?

You can also try: =IF(COUNTIFS([CaseNum],[@CaseNum],[ID],"TC")=COUNTIF([CaseNum],[@CaseNum]),"Tier 1",IF(COUNTIFS([CaseNum],[@CaseNum],[ID],"CA")=COUNTIF([CaseNum],[@CaseNum]),"Tier 3","Tier 2")) Or a bit fancy with one more extra concatenation: ="Tier...

Alan's formula expects your data to be in certain format. Your data is inconsistent so you need to provide rule for placing the alphabet pairs e.g. it will always be AB and therefore the other pair shall be placed after placing 2 digits. Defining problem clearly is the first requisite when you...

Here's how old fashioned VBA might look like. Public Sub KeepSpecificColumns() Dim arColHeadings Dim lngHdrRow As Long: lngHdrRow = 1 '\\ Define the row number here Dim lngLastCol As Long '\\ Define Headings name arColHeadings = Array("First Name", "Middle Name", "Last Name", "Title"...

Formula solution would be to re-arrange the characters to match the sequence and do VLOOKUP. Below formula works with posted data. =IFERROR(VLOOKUP(RIGHT(B2,4)&LEFT(B2,4)&MID(B2,6,2),'Software Report '!B:D,3,0),"") I think these are vehicle number plates from Maharashtra state. जय महाराष्ट्र...

Following can be one formula approach. In cell F2 implement following formula =LOOKUP(2^15,SEARCH('Bank Ledger'!$E$2:$E$4,'Bank Statement'!C2,1),'Bank Ledger'!$F$2:$F$4) Copy down. Note that the results in the third cell won't match as in one cell is having "R52019040272121945" and...

@Marc L I have not tested CURL and the rest of the stuff. I posted only for VBA+CMD part so I am not sure if the rest works or not.

@YasserKhalil I just posted the VBA code for invoking command prompt and nothing more (untested is mentioned as well for CURL part much the same way as Siddharth Rout indicated). I see that you have cross-posted this on stackoverflow and accepted the answer there...

If you are looking for the syntax to invoke Command Prompt through VBA then your syntax would look like below. (Untested) Dim strCmd As String strCmd = Environ$("comspec") & " /c curl --location --request POST ""https://api.imgbb.com/1/upload?key=APIKEY"" --form...

Hi Joseph, What I have posted is fairly straightforward part of parsing the text string. However, it will be difficult to find a suitable formula expression which deals with all different cases (as number of cases and words vary). If you are able to post a clear logic for achieving this then a...

@Peter Bartholomew I do not see it from any particular perspective. It was OP's response indicating he was using Excel 2007 which got me to post this formula. As an aside, I am sure this request has come before and a search on google or this forum may provide a direct answer to it. I believe...

You can try SUMPRODUCT like below. =SUMPRODUCT(LEN(A2:A101)-LEN(SUBSTITUTE(A2:A101,"s",""))) adjust the range to suit.

You can also try following approach. Copy formula in cell B2: =TRIM(MID(SUBSTITUTE(" "&$A2," ",REPT(" ",99)),COLUMN(A2)*99,99)) copy down and across!

Your requirement is not fully clear to me. You can use something like below. =IF(B1>700,700*0.2+(B1-700)*0.4,"Formula for values upto 700!") Add formula in false part...

Hi Sachin, Thank you. I realized that I cannot be prolific like some of the guys here on the forum but I will keep contributing in whatever small way I can.

"-"&LEFT($D$1:$J$1,3)&"-" builds a string like -BRA- Which is then used in FIND function to locate in source string through FIND("-"&LEFT($D$1:$J$1,3)&"-",A2&"-",1) Here the dash after A2 is added to handle if the string exists at end of source string. This returns an array like...

The construct for finding last non-blank cell in a row would be: =MATCH("zzz",1:1,1) like Peter and Guido have suggested.

With the sample data provided, you can use following formula in cell C2. =IFERROR(MID(SUBSTITUTE(LOOKUP(2^15,FIND("-"&LEFT($D$1:$J$1,3)&"-",A2&"-",1),$D$1:$J$1)," ",""),5,99),"Others") Copy down the formula.

You can also use FILTERXML if you have Excel 2013 or higher. =FILTERXML("<data>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A$1,"""sellerId"":""","<td>"),""",""mainSellerId"":""","</td><td>"),""",""sellerName"":""","</td><td>"),""",","</td>")&"</data>","/data/td["&(ROW()*3)&"]") See attached...

With your sample, following formula can work (copy down): =TRIM(MID(SUBSTITUTE(SUBSTITUTE($A$1,""":""",REPT(" ",999),3*ROWS($A$1:$A1)),""",",REPT(" ",999),3*ROWS($A$1:$A1)),999,999))

Little different approach instead of IF. =CHOOSE(MATCH(DAY(B361),{1,11,26},1),"10-"&TEXT(EOMONTH(B361,0),"MMM-YY"),"25-"&TEXT(EOMONTH(B361,0),"MMM-YY"),"10-"&TEXT(EOMONTH(B361,1),"MMM-YY"))+0

You should be able to do "Text To Columns" as described by @p45cal and get your data.

Just curious, try to paste data from PDF to "Notepad". And then copy from Notepad, paste in Excel.