Hello. I haven't had any luck finding an eval-type function to use in a cell for Excel. Let's say I have a cell A1 that contains string "C4". I'd like to be able to write an in-cell function similar to this IF(EVAL(A1)>10,"TOO BIG","TOO SMALL"). That would then effectively be C4>10 for the expression. Is this possible without VBA? ...
This is related to http://stackoverflow.com/questions/3419573/excel-vba-remove-duplicate-rows-by-cross-referencing-2-different-sheets-then-de I can't seem to get any VBA to work well or fast enough for a couple 100 rows. Does Excel have a formula to remove duplicates from one sheet, by cross referencing another sheet? Thanks for all...
What is the in built function for converting from text to FLOAT in Excel (similar to INT()) ...
I am using an array formula (in Excel 2003) to count the number of strings meeting a specific condition. I am using a column of strings instead of a table of cells to store my data because of file size limitations. The formula is below: {=SUM(IF((VALUE(MID(INDIRECT(CONCATENATE(D1,"test")),6,1))*VALUE(MID(INDIRECT(CONCATENATE(D1,"test"...
I am having a worksheet where I am having the values as -------------------- col1 | col2 -------------------- 1 | 2 min 30 secs 2 | 1 min 24 secs 3 | 0 min 10 secs 4 | 1 min 3 secs Now I would like to sum up all the values in col2. Sum will be: 4 min 67 secs. ...
Hi My team leader wants me to check if this is possible. Our app has a grid (we use TAdvStringGrid from tmssoftware) that displays some values. Our users then copy and paste to Excel. (2010) Now they want the values to update automatically when they play with Excel. In other words, I need to copy formulas similar to having a Excel shee...
Problem: I have data that looks like this and I want to compare the rows to the column values. so is(Table1.t1 = Table2.t1)? kind of thing. Table 1 A B x t1 x t2 x t3 x t4 Table 2 A B C D E x t1 t2 t3 t4 Can I do this in Excel with functions or VBA ...
Hi all Need help with a Calculated column issue in SharePoint 2007 Basically, I'm trying to take the value from the [Contact E-Mail Address] column and remove the mailto: part infront which Sharepoint automatically created. Original Column Value : mailto:[email protected] Calculated column required value: [email protected] This is what i've go...
Hi, I am trying to do simple thing: I just need to set some cells to values that are on the previous rows. I have tried =A(Row()-1) but it does not work. Thanks in advance ...
Hi, I would like to create a dynamic function in excel (no VBA) to pass the value of a variable to a number of similar functions. Example: instead of doing: =sum(a1:z1) =sum(a2:z2) =sum(a3:z3) and then rewrite all functions to do: =sum(a1:t1) =sum(a2:t2) =sum(a3:t3) I would like to do: =sum(a1:"var"&1) =sum(a2:"var"&2) =sum(a3:"var"&3) ...
When writing an Excel formula, does it make a difference whether you set a value to true, "true", or true()? In other words, which of the following is the best? Or does it depend on the circumstances? if (A1 = 1, true, false) if (A1 = 1, "true", "false") if (A1 = 1, true(), false()) ...
Hi, I want a customized format(with milliseconds also) in such a way to handle for a date and time in Microsoft Excel. Sample date and time: 08.25.2010 00:52:09.359 For understanding of above sample date time, it is 25th August 2010 12 hrs 52mins 9seconds 359 milliseconds(AM). Please provide a custom Format to handle the above mention...
So I am writing some formulas for my spreadsheets and wondered if there was a placeholder for this row number. For example say I am using the formula: =C4+SUM(F4:N4) I know I can autofill this, but what I really want is some stock formula like: =C{this.row}+SUM(F{this.row}:N{this.row}) Is this possible? Thanks ...
What are the set excel formula for calculating 1) Median Absolute Difference MAD ...
Hello, I have looked into every nook and simply cannot find the exit here, so if anybody can, please provide some insight.. (Mac OSX user - MS Excel 2008 (no VBA) I have a list of content categories (string) from different sources (index) and my task is to create a list for a mapping document that will concatenate (or not) each row fro...
I have been going crazy trying to make a VBA code to do the following - I will explain it the best I can. I have 2 Sheets, one named Pay_balance and the other Debtor_list. The Debtor_list Sheet is a Table from Cells A2:B13; A1 & B1 are Headers ("Debtors" and "Balance"). Both columns have names assigned ("Alldebtor" - A2:A13 & "Allbalanc...
I made a Sheet which I have now converted to a UserForm but the VB code I was using no longer works, I will copy the old code used and the new one which keeps telling me "Debtor not found", any help would be Appreciated. Old Code: Sub Buy_Click() Name = Worksheets("Purchase").Range("G19").Value Amount = CSng(Worksheets("Purcha...
Which formulae in MS Excel can we use for - equi-depth binning equi-width binning ...
How would you perform binarization of an attribute with five categorical values in excel? ...
I want to count all the unique values in an Excel column that contain a certain string. For instance, say I have this in my column: strA strB strA strC diffA diffB strC If I give this theoretical function that I'm writing a value of "str," it will count the unique values containing "str", and give me back the number 3. Any suggestio...