Loading...

Follow Excel Help Forum on Feedspot

Continue with Google
Continue with Facebook
or

Valid
Hi All.

I have an excel worksheet with about 10000 records. (brands) Some of those records might have been incorrectly spelled so we end up having double entries of similar brand names. For instance. Alfa Beer also spelled as Alpha beer, or Da Noi spelled as Danoi or KRONENBOURG spelled as KRONENBURG. I need some formula that will identify cells containing similar text. Ideally the formula would identify all the entries which contain at least 4 identical letters regardless of their position in the cell. I tried using =MATCH("*"&LEFT(A2,3)&"*",B$2:B$10654,0) but this one can only identify based on the first 3 letters of an entry. Even though it may identify some entries, not all will be found.
Any ideas will be appreciated!
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi Gurus,

I am looking to create some automated reports from data in a spreadsheet and was looking for some assistance.

I am concatenating text and data to form the reports and would like to base that commentary on data in cells.
ie- If the total sales have increased this month then list the drivers of the increase.

eg Total Sales increased 5% this month and were driven by an increase of 6% in car sales and a decrease of 1% in bike sales.

Conversely, i would like to put the bike sales first if they were causing the increase.

eg Total sales increased 5% this month and were driven by an increase of 7% in bike sales and a decrease of 2% in car sales.

I am fine with identifying the increase/decrease using isnumber(search), but am struggling to find a way to have excel report in the correct order.

Hope this makes sense.

Cheers,

G
Attached Files
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Excel Help Forum by Kumawat_s - 8m ago
I have an excel sheet which I use for costing of my products having different ingredients with different prices. File attached for reference.
I want an output as per sheet “Output” column D3.
Please suggest.
Thanks,

Shubhkaran
Attached Files
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi All,

I'm seeking help off you good people. I'm trying to find a formula that will search for the "right" most "-" and return all characters to the left of it.

E.g.

PI-140568- would become PI-140568
PI-140573-17 would become PI-140573
PI-1991-2 would become PI-1991
PI-110869 would remain as PI-110869

Warm Regards and thanks in advance for any help.
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi,

How could I use excel conditional formatting for the case where:

-column A I have the dates when an order has been placed
-column B I have the date when the order has arrived
-column C I have the date when they are estimated to arrive.

I would like conditional formatting to mark the row for all 3 dates, where an order has been placed (column A) but the estimated arrival date is missing or the estimated arrival date has passed already.
Any help is appreciated.
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi all,

I am working with VBA for a short time now and have come to a problem I cant solve. I have drivers to schedule on cars. The amount of drivers is stationary and their availability i can produce with formula's but appointing them to a not fixed amount of cars (trips) is what I trying to figure out. Please, help.

Knipsel.PNGplanning.xlsx
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Peak X Keto As we understand that, weight loss is not a easy challenge for all of us. Some of them get frustrated by using antique techniques to lessen weight but the time has come to include another and safe method to decrease weight in short time. A portion of the overall populace's are jogging wit
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi,

i have table like this:

Screenshot_9.png

And code for this is:

Code:
Option Explicit

Sub test()

Dim arrayTable As Variant
Dim i As Long

arrayTable = ActiveSheet.ListObjects(1).DataBodyRange

For i = 1 To UBound(arrayTable)
    If arrayTable(i, 4) = "Test" Then
        arrayTable(i, 4) = "ChangeTest"
    End If
   
    If arrayTable(i, 5) = "Ok" Then
        arrayTable(i, 5) = "ChangeOk"
    End If
   
Next i

ActiveSheet.ListObjects(1).ListColumns(4).DataBodyRange.Resize(, 2) = _
Application.WorksheetFunction.Index(arrayTable, 0, 4)

End Sub
now i do not want to populate whole table from array - only 2 columns.
And i am using index for this one.

The problem is that i have to use it 2 times like this:

Code:
ActiveSheet.ListObjects(1).ListColumns(4).DataBodyRange = _
Application.WorksheetFunction.Index(arrayTable, 0, 4)

ActiveSheet.ListObjects(1).ListColumns(5).DataBodyRange = _
Application.WorksheetFunction.Index(arrayTable, 0, 5)
it is possible to do this only one time?
To output only column4 and column5 to table in one time?

I do not want to output array to whole table because in my real data numbers like "12.3" are changed to "12,3" so i prefer to avoid this.

Best,
Jacek
Attached Files
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi,

I tried using the below code but it failed. I am new to VBA so Im not too sure about the rules in writing a VBA code, but I am trained in Matlab. Please find attached for the desired result from this code

Sub IF_Loop()

Dim cell As Range
Dim Count As Long
Count = 3
For Each cell In Range("Table1")
If cell.Value <> "#" Then
cell.Value = Range("B&Count").Value
Else
Count = Count + 1
End If

Next cell

End Sub

Thank you.
Attached Files
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Excel Help Forum by Asifmian55 - 2h ago
Friends:
I am creating a directory of our community. I have information about the families but I would like to add picture to this information so people can easily reconcile name with pictures.

In the attached spreadsheet I have three worksheets (1) MAIN DIRECTORY, (2) DIRECTORY and (3) PICTURES. I want to use a LOOKUP/INDEX or MATCH functions to get pictures from the PICTURES worksheet and paste them against the correct name in MAIN DIRECTORY.


Can anyone help me to sort this out. I tried many different ways but not successful.

Your help will be very highly appreciated.
Attached Files
Read Full Article

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview