similar

=IFERROR(INDEX('Summary (WA1)'!B:B,MATCH(A2,'Summary(WA1)'!A:A,0)),IFERROR(INDEX('Summary (WA2)'!B:B,MATCH(A2,'Summary(WA2)'!A:A,0)),IFERROR(INDEX('Summary (WA3)'!B:B,MATCH(A2,'Summary(WA3)'!A:A,0)),IFERROR(INDEX('Summary (WA4)'!B:B,MATCH(A2,'Summary(WA4)'!A:A,0))&"","")))) Is there ashorter...

Good Day!! I am a long time user of the Mr. Excel Forums. THEY ARE GREAT!!! I am looking for recommendations for a similar forum for Microsoft Flow. Thank you in advance!

Hi All, I am having trouble adding a RAG rating to the right of an excel Graph. Is anyone able to help? https://www.guysandstthomas.nhs.uk/resources/about-us/board-minutes/2018-board-papers/february/board-of-directors-performance-report.pdf Something similar to Page 50 on the link above...

I have a TextBox on a UserForm that displays the results of calculations done inside the UserForm's code. I build up a string using the concatenate operator along with spaces (" ") and the values. When all calculations are finished, I print a report similar to the following: input output...

Hello, My excel file is getting very heavy & opening minutes to open, due to the formula below pasted in all rows of Table6, I want to get any alternate VBA code to arrive at values using similar search criteria s. =INDEX(Table1[MARK NO./DESCRIPTION],MATCH(CONCATENATE([@[WO...

I am trying to filter and/or sort a data series, but it is not working. Every cell in the series is driven by a formula pulling info from other cells in the workbook, but I don't think that should be an issue because I have similar setups in other workbooks and it works fine. Any idea why...

I have a worksheet where I have a column of Claim Numbers (column AS), and a column of LOAs (column A), and I need a formula that looks for "is there more than one claim number per LOA?" I have a few other similar formulas, but can create them once I get the help I need creating this first one...

Hello, I have an issue with an IF AND function that contains similar criteria. Example: Agents have their days off and their week is formatted. IE: Tuesday/Wednesday off will look like this FYSM--R. Some agents have 3 days off, Tuesday/Wednesday/Thursday off will look like this FYSM--- I have...

Hello, I have a table that it's exported from another software. it's something like this: https://docs.google.com/<wbr>spreadsheets/d/13A-<wbr>iAbq0X18G9vBmou5KqDcaF-u_<wbr>jK7vxOoL1HY5YNE/edit?usp=<wbr>sharing and it repeats at each diferent No_ And i need it this way or similar...

I've been researching for a formula to give me a score of similarities between cell a2 and b2? There are no exact matches in my data, case sensitivity is not an issue. I see many macros/VBA but I don't have any experience in using these. Is it possible to create the 'Levenshtein distance'...

I was just curious if it's at all possible to make column 1 (or actually 0) in a multicolumn listbox always visible as you scroll right. Similar to how freeze pane works on a spreadsheet. If not, that's ok. I'm just curious.

Hello I have a two lists of numbers. The numbers are from 0.0001 up to 1,999,999,999. I want to find the pairs of numbers that are quite similar, i.e.within +/-5%. How can I do that? I was thinking to round them up and find exact matches, but they have large difference. What do you suggest?

Okay it is what you think :) 1. I made a GIGANTIC code which traverses the entire workbook. And right when I was almost done, I got "procedure too large." This appears to be because the compized size of teh sub is > 64 kb. 2. I do not want to break into two subs, because the setup is so...

Hi all, I am a VBA novice trying to get the syntax correct for auto-populating a form that I have where I need an OR condition, or something similar. In a regular workbook, this would be a matter of creating an array formula or adding two sumifs together. I'm not as sure how that works in the...

Hi all, I have an unusual VBA Out of Memory Error. I have a spreadsheet which I have restored from backup, which opens fine, behaves fine, and does all it should (it contains about 10 modules, none of which is bigger than 64kb). It contains a couple of very small forms. It also contains about...

Hi there I have a 9 box grid, each box has a value 1 to 9. I want each box to highlight its value if conditions are met in other cells. Example. 1. If 'A' <1.49 AND 'B' <1.49 then I want box 1 in the 9 box grid to show value '1'. 2. If 'A' >2.5 AND 'B' >2.5 then I want box 9 in the 9 box grid...

I have a worksheet that is similar as follows <tbody> ItemNum A B C D E A 50 50 A 50 50 A 50 B 40 40 B 40 B 30 </tbody> How can I combine the items that are the same all on line?

Hello! I wrote a a message some days ago getting back a partial answer only, so I post it again in a more clear form. I have an Excel workbook, containing more spreadsheets. Some of them have an identical structure of tables (from An 1 implementare to An5 – see the Dropbox link file), whereas...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hi, I currently have the code Cells(Rows.Count, 2).End(xlUp).EntireRow And this selects the last row with data. However, I want to use a code similar to offset, I want to select the next row after the last row with data. Similar to what i have for last used column Dim LC As LongLC = Cells(7...