Tech24 Deals Web Search

Search results

1. Results from the Tech24 Deals Content Network

2. excel - How to show current user name in a cell? - Stack Overflow

   stackoverflow.com/questions/6934169

   if you don't want to create a UDF in VBA or you can't, this could be an alternative. =Cell("Filename",A1) this will give you the full file name, and from this you could get the user name with something like this:

3. excel - Specifying range from A2 till infinity (NO VBA) - Stack...

   stackoverflow.com/questions/46601997

   If you want to refer to a range starting from A2 until max row (1048576 or 65536 for Excel prior to 2007), you can use this volatile formula... =OFFSET(A2,0,0,(COUNTBLANK(A:A)+COUNTA(A:A)-1),1) . Use formula as a defined range name or inside other formula which takes range as an argument (for eq SUM)...

4. excel - Return values from the row above to the current row -...

   stackoverflow.com/questions/3549000

   To solve this problem in Excel, usually I would just type in the literal row number of the cell above, e.g., if I'm typing in Cell A7, I would use the formula =A6. Then if I copied that formula to other cells, they would also use the row of the previous cell.

5. Using "If cell contains #N/A" as a formula condition.

   stackoverflow.com/questions/20962940

   A possible alternative approach in Excel 2010 or later versions: AGGREGATE(6,6,A1,B1) In AGGREGATE function the first 6 indicates PRODUCT operation and the second 6 denotes "ignore errors"

6. Add leading zeroes/0's to existing Excel values to certain length

   stackoverflow.com/questions/3992541

   There are many, many questions and quality answers on SO regarding how to prevent leading zeroes from getting stripped when importing to or exporting from Excel. However, I already have a spreadsheet that has values in it that were truncated as numbers when, in fact, they should have been handled as strings.

7. Ignore Duplicates and Create New List of Unique Values in Excel

   stackoverflow.com/questions/13307927

   Another approach, since Excel 2016, is to use Power Query. Howto: select the data (including the field name), use menu Data > From a table or a range, (Excel will change your sheet into an Excel Table, which is very convenient), in the Power Query Editor, right-click on ColumnA (the column header), and Remove duplicates,

8. How to loop in excel without VBA or macros? - Stack Overflow

   stackoverflow.com/questions/4939537

   This was a difficult question to answer when it was first asked in the year 2011. However, Excel has grown up since then. The easy solution to the original problem is to use the following formula: =CONCAT(IF(C1:C40>=99,A1:A40,"")) However, the OP also asked if we can make a loop within a spreadsheet formula. With Excel 2023, the answer is yes.

9. Excel: Leading Zeros on Dates.. Formula to do it for me?

   stackoverflow.com/questions/1533413

   There is a simple way to maintain the leading zeroes in Excel. Simply add this to the cell and type whatever value you need and the zeroes will be retained. For ex: If I want 0000000023. Type into a cell '0000000023. That ' symbol seems to retain the zeroes as long as you type it before the values.

10. Return empty cell from formula in Excel - Stack Overflow

    stackoverflow.com/questions/1119614

    I need to return an empty cell from an Excel formula, but it appears that Excel treats an empty string or a reference to an empty cell differently than a true empty cell. So essentially I need something like =IF(some_condition,EMPTY(),some_value) I tried to do things such as =IF(some_condition,"",some_value) and =IF(some_condition,,some_value)

11. Excel: Can I create a Conditional Formula based on the Color of a...

    stackoverflow.com/questions/20008632

    On the Excel Ribbon, go to "Formulas" and click on "Name Manager". Select "New" and then enter "CellColor" as the "Name". Jump down to the "Refers to" part and enter the following: =GET.CELL(63,OFFSET(INDIRECT("RC",FALSE),1,1)) Hit OK then close the "Name Manager" window. Now, in cell A1 enter the following: