dear

Hello Friends, I have a complex problem that I need to solve. I would like to have the following results: Column A has 5 digit numbers. Of all the numbers that are consecutive in column A, I would like to have all of the digits that are consecutive deleted and print only unique...

Hi, I have a textbox where whenever I click to write an email, the cursor shows up below the word "regards", but I want the cursor to show up in between the words "regards" and "Dear Sir". Here's a screenshot of the textbox: [/URL][/IMG] Here is the code that I used as well: _Subject =...

Dear Sir, How to fill combobox with values from another workbook in VBA Regards

https://imgur.com/a/5HUdECj Dear Experts, With reference to the attached table, is there any excel formula that could assist to find the 10th number after Number 1 in Column A (which is 14). I would greatly appreciate if you could assist on this. Thank you! Regards, Brian

Dear sir Please tell me =_xlfn.Numbervalue function with examples

Dear all Could you help me with this issue please? I would like to sum only the transaction that does not contain "APPLE" Ex : <colgroup><col><col span="3"><col></colgroup><tbody> Num Name Debit Credit 1 APPLE 1000 sum only Num 2 and 3 1 ABC 100 due to 1 contain "APPLE" 1 001 900...

Dear All, Good day/night. I have a tabulate consisting of the following inputs: Beg. Value(A1) Purchases(B1) Sales(C1) End. Value(D1) Formula(E1)=If(.... I'd like to create a formula to be able to divide the (Ending value/Beg. value) -1, but with slight adjustment. I'll explain...

Dear friends and respected seniors :) I have this data starting from cell a1 to d8 :biggrin: A 2 5 5 A 3 5 12 B 6 12 -3 B 4 12 B 2 12 C 1 -3 C -6 -3 C 2 -3 I am comparing the contents of column A and summing up similar data from column B a1 and a2 has A, hence 2+3 = 5, a3, a4 and a5 have...

Hello dear users, i use this formula =IFERROR(SMALL($C$2:$C$991,B2),"") to get numbers from c2:c1000 there are 3 results but formula shows only 2 results and if there 10 results it shows 9. can anybody help me please? C contains this formula : =IF(ISNUMBER(SEARCH(Sheet1!$K$2,A2)),B2,"") Regards

Dear, i have used this: =AVERAGEIFS($N$4:$N$981;$J$4:$J$981;">="&(5&$AG8)+0;$J$4:$J$981;"<="&EOMONTH(5&$AG8;0)) for getting average of specific column while beside contains specific month. N Contains Number J Contains Dates AG8 Contains May but this formula seems doesn't consider that dates...

Dear All, I have below sub for creating the email - from data inputted in user form I would like to know whether it is possible to convert the list of Case details in tabular format instead of list. Sub Send_Email() Dim olApp As Outlook.Application Dim olemail As Outlook.MailItem Dim...

Dear All, how do I create a stacked bar chart. please help.

Hello all, I have an Index and Match Formula that looks like the following:- =INDEX(Sheet2!A:A,MATCH(Sheet1!A1,Sheet2!B:B,0)) Data in Sheet 2 is :- Col A......Col B <tbody> hello hello dear dear my my what what is is going going on on </tbody> Data in Sheet 1 is :- Col...

Dear Guys Good Morning Can you amend my vba as per attached link https://www.dropbox.com/s/mqecoiuv3kwlnv2/TESTING3.xlsm?dl=0 Cell A6 JOHN MR SMITH AND MR STEVE JACK result should be Dear Messrs in B6 and Banking Facilities in cell C6. tHANKS/REGARDS RAKESH

Dear Guys Any help on the below formula =IF(COUNT(SEARCH({"MR","AND","MRS"},C2)),"Dear Sir/Madam"," ") it works well for example for MR JACK SMITH AND MRS JACK SMITH. But for MR JACK SMITH only it does not work. If in cell c2 name is MR JACK SMITH then result shall be "Dear Mr"...

HI Guys i have the following table I L S Mr John Smith Mr Jack Paul and Mrs Jack Paul my vba codes are as follows:- Sub x() Dim TR As Long TR = Cells(Rows.Count...

Dear Excel expert, Please advise how to move the legend inside the chart Picture is available in here https://ibb.co/kgmw8R

Dear All, Can you please help me in reduce the below formula please.. I appropriate you in advance to look my query..

Dear all i want to remove the starting zeroes source 000046 000001 000123 005426 012345 876541 output must be 46 1 123 5426 12345 876451 could you please provide the formula?