All Questions
32
questions
0
votes
1
answer
843
views
Conditional formatting for specific group of values/rows based on cell value(s)
I am having some data table that is separated in lets say "blocks" of rows. As you can see on the image, starting from Column D (A1) there are some values in first row, and then 5 rows empty ...
0
votes
0
answers
114
views
Excel: Dynamic change cell with Date/Time when any other cell is changed in the worksheet
I am trying to decypher a formula which will stamp auto Date/Time or some text when I change any random cell (more instances) inside some certain range (for instance A1:K45).
What I did is for one ...
0
votes
0
answers
39
views
How to replace formulas into values but with possibilty to remain referenced to its original source (dynamically)
I would like to have the possibility to convert some formula (in my case CONCAT) into values, but with the possibility to select those values and not to have formula shown, and also to be able to ...
0
votes
0
answers
904
views
Excel 2013 - Assign value to cell in Sheet2 based on a conditional in a cell in Sheet1
I would like to assign values to cells in one sheet based on the values of cells in another sheet. I have followed this answer, but it appears to work only if both the reference cell and the target ...
0
votes
2
answers
75
views
Unable to Extract the Specific cell value against the lowest Priced item in a excel column and paste it to different worksheet
I am trying to extract from an excel file(named as book1.xls) the lowest Price present under the 'Price' column of the sheet1 and want to copy it along with it's respective value which is present in ...
0
votes
2
answers
387
views
How to use an Excel User-defined function UDF in Sharepoint's list calculated column?
Thanks to a very good article found on the web, I have build a "TRANSLATE" fomula in Excel (actually VBA code that queries google translate and returns the translated word/sentence in the choosen ...
1
vote
1
answer
267
views
Can standard excel errors be trapped at input of a custom VBA function?
I would like to know if there’s any way in Excel VBA custom function to recognize that the input data is one of the standard Excel errors e.g. #DIV/0!
Say I have a very simple Excel VBA Custom ...
1
vote
1
answer
487
views
Prevent Function from Being Called Repetitively
I wrote a custom function to concatenate a range, using a custom concatenator.
Public Function mikeConcat(rng As Range, concatenator As Variant) As String
if left(selection.value,1)="'" then ...
2
votes
2
answers
181
views
Removing Duplicates Across 3K Rows, 9 Columns
I have an Excel 2010 table of 3,800+. I would like to identify duplicates across 6 columns, many with text, some with IP addresses and hostnames, so that accurate data is reflected. I've tried the old ...
3
votes
2
answers
4k
views
Apply Conditional Formatting VBA to All workbook Sheets
I am very new to this, I am making conditional formatting to highlight numbers above the average of all values in a row.
I need to apply this formatting to all rows in all sheets in the workbook.
...
0
votes
1
answer
3k
views
Excel date to day from sheet name
I'm using this code to grab the sheet name and put it into cell C2.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
I would like cell C1 to display the correct day of the week (ddd) ...
0
votes
1
answer
5k
views
Excel If formula to vba
I have this formula which checks a cell to see if its a 6,2,a, or b, in which case the word cash is written.
=IF(OR(ISNUMBER(SEARCH("6",M2)),ISNUMBER(SEARCH("2",M2)),ISNUMBER(SEARCH("a",M2)),...
-1
votes
1
answer
2k
views
Excel 2013: Time/Date Stamp upon change in cell value
I am using Excel 2013 on a PC running Windows 7. In Excel, if cell A1 changes from one value to another, I would like a date time stamp to appear in cell B1. Assume cell A1 could be blank or filled ...
1
vote
2
answers
539
views
How to convert a table into summary as shown
I have table as below. I want to add rows for a category and sum all (excluding null) same species (say lemon), same species length under each category
.
Now i want to consolidate the table as shown- ...
0
votes
2
answers
2k
views
Excel 2013, combine CountIF + VLookup
I have the following issue, and I need advice on which formulas to use or if I'm better off trying some VBA codes? (I have no idea!):
I'm working at an Excel 2013 sheet which has the following data (...