helps

Hello everybody. I've been studying some of the solutions found in mrexcel.com about dictionaries. Having applied them "blindly" to my issues with success, I've decided to understand better their dynamic. Suppose I've a table like this: https://imgur.com/h2sfGql How can I build a dictionaries...

Hello All, How can I sort a table into another table on the same row in different columns as shown in the example below. The sort based on data in the row #2 from high to low (descending). Thanks in advance for any helps. *BDT <tbody> A B C D E F G H I J K L M 1 Source 1 2 3 4 5...

Hello, Perhaps I'm a bit rusty here. I've changed a worksheet codename to "wsToC". Now I'm trying to select that worksheet in a subroutine as follows: wsToC.Select However, this is causing a 1004 error. Your help's appreciated.

Hi guys!! Just joined MrExcel so this is my 1st post/thread and I'm new to vba. I work in finance and have the following formula which I use to contra/net-off entries that cancel each other out i.e. debit 25 credit -25. I use this is various workbooks which helps me identify those values which...

I have a series of Dynamic cells with If(something="","",do something else). My problem is that counta or xldown etc, see the empty cells as having data. Is there a way to have them seen as being empty. I do want to cut paste elsewhere if that helps. Thanks.

Hi I've read through all the posts I can find however I can't seem to find one that helps me work out where i'm going wrong. This is what i currently have =IF(B2:B8="Y",char(80),IF(AND(D3<$A$1,B2:B8<>"Y"),CHAR(39),CHAR(137))) Here's what i'm trying to achieve If ALL cells in the B2:B8 range...

Hello, I need a help to get Multi-quantity for multi-BOM, example: actually in Multi-BOM, A3 need 4pcs Layer. No. Qty Multi-Qty 0 A1 1 1 A2 2 2 A3 2 3 A4 1 1 A5 2 2 A6...

I want to highlight the cell directly above a certain value in one column. A B 1 2 2 3 4 5 6 7 8 2 9 10 2 11 12 2 13 my value would be 2 and I want to highlight 1,8,10, & 12 hope that helps ~DR

hi all... how to distribute this data below : Excel 2007 32 bit DEF 2data1data2expected result 3707070 418045180 54545 64545 74545 815238152 93838 Sheet: Sheet1 any helps much appreciated... m.susanto

hello all.. how to make this below code it works : =char(code(e11)+1) a cross post https://www.excelforum.com/excel-formulas-and-functions/1208807-fill-alphabetic-series-with-interval-row.html any helps is greatly appreciated. m.susanto

Hi, I found this project* on Code Project: Excel user defined functions unlimited - CodeProject and find it very interesting. I tried to go through the articles and did what needed to be done to get the Sample Project up and running but it failed. Have you ever tried it and did it work for...