Search results

Your date formula part is returning a string. For starters, following edit gives £51.00 as answer in cell O27. =SUMIFS(A:A,E:E,">="&DATEVALUE(N23&"-"&$N$2),E:E,"<="&EOMONTH(DATEVALUE(N23&"-"&$N$2),0))

Without seeing the actual sample it would be tough to answer but if you want the reference ranges to be constant then you can make them absolute instead of relative. See below reference. http://www.cpearson.com/excel/relative.aspx

You can use a standard construct in cell B2 and copy down till list ends. =IF(ISNA(MATCH(A2,$A$8:$A$8,0)),"",IF(COUNTIF($A$2:$A$5,A2)>1,"Duplicate",""))

Formula solution would probably be too much unless VBA is used. Other simpler alternative would be: 1. Copy DATA column to RESULTS column 2. Select RESULTS column 3. Invoke "Find and Replace" 4. In Find field, put "" without quotes. 5. Keep replace field blank. 6. Choose Replace all...

In that case, try bosco_yip's suggestion.

What option are you choosing when you open this workbook with respect to Links? Excel will prompt you to choose an option like below.

Another better (from speed perspective) alternative to FSO is Shell object. Associated coding is fairly similar. Refer attached example.

Hello Sachin, Your request is not clear. You will have to describe requirement clearly to get help from the forum users. What do you mean by splitting data on the basis of column value in B? Do you intend to split it into different worksheets or do you want to split some columns? Explain...

@Leicester City Fox Fluff13 isn't wrong in pointing out the cross-posting. Have you read below link before? If not then please go through it. https://www.excelguru.ca/content.php?184 This forum is quite lenient on forum cross-posting but some other forums are not so it is good to be aware!

Slightly different approach which works with your data. =IF(LEN(TRIM(SUBSTITUTE(E2&",",LEFT(E2&",",FIND(",",E2&",",1)),"")))=0,"OK","NOT OK")

Your information is insufficient to respond. Consider providing following information: Initial file you get from SAP. Provide example and how you import in Excel. What do you do with it in Excel? Your method of saving it in Notepad format from Excel.

FWIW, fonts and size won't matter if it is DB. But character set and field length will matter for sure. I suppose GraH-Guido has a point. @DashboardNovice what if cell has more characters than you are specifying in column limit?

Based on your inputs I have revised code. It is final offering from my side. You will have to do further amendments if requirements change again! I have added code to copy the output to other sheet. Read the code and edit it to suit. Currently, it will give you output on second sheet. Public...

You have changed requirement which you should've stated in the first post itself. Is this your final layout?

Something like below should help you. Public Sub TransposeData() Dim lngOutRow As Long: lngOutRow = 6 '\\ Change to suit Dim lngOutCol As Long: lngOutCol = 9 '\\ Change to suit Dim i As Long Dim objDict As Object: Set objDict = CreateObject("Scripting.Dictionary") objDict.CompareMode =...

For first two items, modify following lines: wksNew.Name = objFile.Name wksNew.Range("A1").Resize(UBound(varContent), 1).Value = varContent to wksNew.Name = Replace(objFile.Name, ".txt", "") wksNew.Range("A1").Resize(UBound(varContent) + 1, 1).Value =...

See if this code helps you. It should create a new unsaved workbook every time you run this macro... Public Sub ReadTextFilesInAFolder() Const cStrPath As String = "C:\Users\E5554593\Desktop\New folder" '\\Change this path to suit Const ForReading = 1, ForWriting = 2 Dim objFSO As Object '\\...

For your information, Application.FileSearch was deprecated long back. It will work in Excel 2003 and lower versions.

Sledgehammer :DD It is plain data splitting and then pasting in individual cells.

See if this code helps your case. It should read from column A to C and will output results on F to H. Public Sub SplitData() Dim ws As Worksheet Set ws = ActiveSheet Dim varOutB, varOutC Application.ScreenUpdating = False ws.Range("F:G").ClearContents For i = 2 To ws.Range("C" &...

Should it not be? =AND(F1>=TODAY(),F1<=(TODAY()+5))

You can use popular LOOKUP approach like below in cell C2 and copy down: =LOOKUP(2^15,SEARCH(TRIM(B2),Data!$B$2:$B$7,1),Data!$C$2:$C$7)

If you don't need the formula to be available post running the code e.g. you are converting them to values etc then you should use VBA native methods to arrive at the results.

Happy to know this!

You have posted a full essay here :DD. I'd recommend following edits to your question. Build a sample data grid and post like below so that someone can at least copy it and build by using Text to Columns etc. Row# | Col A | Col B | Col C 1|Yamaha|FI|1000 2|Suzuki|Carburetor|5000 Then it boils...