custom formula

Hello Team, I need to develop a custom primary key in Excel, i.e. based on multiple columns data, it should be a unique combination and none of the cells data can be NULL. For example, data in Column A, B, C, D form an unique pair. So I need to restrict a user to enter duplicate entry for...

Hi I have an excel macro enable spreadsheet, that exports the contents into a text file. It has three columns in the xls that is used to capture amounts with two decimal places and these are formatted as text fields. When the macro runs it left pads the amount columns with zeroes to get a 16...

Hi guys, I have Created Custom Function with three arguments and all three are range values from two different sheets. the custom function is returning the double values and it is getting placed in the cell correctly, Now the thing is, when i delete or perform other operations in the tool...

Hello everyone on this forum, I just made a custom function that allows me to check if a string does satisfy a regular expression. If I enter the formula into an empty cell, it works perfectly fine and returns a boolean. However, if I want to use the exact same formula in Data Validation, it...

We have booths for rent and I have put together a sheet that I can list the dealer #, the booth # they occupy, the sales $, and it will calculate the sales per square foot. The booths are classed as different types based on the location of the booth (Type 1=1st floor front, Type 2=1st floor...

I need to create a custom formula for a validation test with the requirement being 4 digits and a value within the range of 1000 and 6900. This could be simply accomplished by using whole number range and specifying the values, as it would be impossible to have an entry that was not 4 digits...

Hello all! This is my first post on here. From what I have seen, you guys are enormously helpful. I thought I would put forward my questoin I have hit a wall trying to create a custom function in VBA. I am trying to find unique values in a list of copied values in some column. This is...

First time poster, have received a lot of help from reading other posts, so thanks in advance! Let's say that A1 is where a user can put in a date, such as 1/1/16, but is left blank otherwise. Let's then say that cell B1 is set as follows =IF(ISBLANK(A1),"N/A",480-SUM(P:P)). Let's then say...

I have two problems one is if i have empty cells it will not work and second that it does not calculate on tables when using sum column5 Thanks for any help provided Public Shared Function TotalSumToNearest(Nums As Object) As Object...

Hello, I have a custom built formula module which converts numbers into Lithuanian words (i.e., it would convert "22" to "twenty two", only in Lithuanian). The code is provided bellow. But the formula can not output special Lithuanian characters, such as ą, č, ę, ė, į, š, ų, ū. It gives...

I have four custom formulas that I use a lot. Countcellcolor, Countfontcolor, Sumcellcolor and Sumfontcolor. Co-workers would also like to use it, but they always ask me what the input format is. I would like to add details to the functions so that they can use it independently.</SPAN> Is there...

I want to restrict entry by user of a value unless they have already entered in other cells : I have a Minimun Value (MinVal) and Max Value (MaxVal) defined <tbody> A B C D E 1 Status Date Amount 2 100 Require Data validation formula to restrict 3 entry in D2 unless B2 is filled...