e.g

hey would it be possible to copy data from one work book to another but ignore any blank cells on the original workbook? e.g. I have this one workbook where only columns A, C, E, G etc have data in them. I want to copy that data into the 2nd workbook but don't want to copy the blank...

Hi I need to create a column with groups so the first variable is from 0 to 14 the next is from 0 to 14 and the last is 0 to 21 i need an easy way for excel to write all the different combinations down e.g 0-0-0 1-0-0 2-0-0 and so on or else i need to write them all down please help

Hi, I have a tricky one regarding count/len of text in a cell. This excel sheet is used to upload data to our stock management system. There is a limit of 30 characters per line but we can put more if each line is separated with a | . E.G. of a cell content: This is NOT OK "This product...

Dears, I would like to do the following with conditional formatting: Fill the cell (e.g. a3) with the RED colour if the corresponding cell in column B (e.g. b3) is blank. Kindly advise. Thank you!

<tbody> A B C 1 2 TEAM 1 TEAM 1 TEAM 2 3 TEAM 2 TEAM 1 TEAM 3 4 TEAM 3 TEAM 1 TEAM 4 5 TEAM 4 TEAM 2 TEAM 3 6 TEAM 2 TEAM 4 7 TEAM 3 TEAM 4 8 </tbody> Hy all, i have in column A, (starting in A2) the above: I now need all the combinations of games ( just 1 round)...

Hello all, This will be easy to most of you, but i spent already more than couple of hours to search for solution, and cannot find correct way to work... Forgive me for being computer-illiterate. I need function for this case: To check value in D7 cell, and if value is only between 0-0.04 or...

Hello all, How can I use the Code() function in VBA e.g. Code(ActiveSheet.Range("A2")). Thanks, Brian

Hello Excel Experts!! As I have no experience in coding whatsoever, I am here to seek assistance. I am trying to create a function such I can hyperlink and open pdf files directly from an excel spreadsheet. There is a Main Directory containing the "Excel file" and a Sub-folder containing all...

Hello, I would like to rate each item to find out why my "bread and butter" items are. e.g. ITEM1 would get something like CC and ITEM2 CA and ITEM14 AA. what formula can look at all items and score according to preset rules (e.g. top 10% = A and so on) <colgroup><col width="64" span="3"...

hey I have a long list of formulas in a column, around 30k rows. I've noticed every so often some of the cells don't have a formula but are hard coded with data. Is there a way to sort by the formulas rather than the data showing? e.g. I have a bunch of similar formulas like this...

I am using below function to search a string for a matching word from another string and the logical test is performed and if true (e.g., XXX), the value_if_true output is given (e.g., YYY), else the output in the value_if_false parameter is given...

I am trying to extract data from a cell(s) that contains surname, first name, middle name. e.g bloggs, john charles I am just after the surname e.g. bloggs The following formula works well for my data. =TRIM(MID(SUBSTITUTE(SUBSTITUTE($H12020,",","")," ",REPT("...

Hi All, I'm stuck on some CF and hope someone can help please :) I want to CF to highlight non-blank cells if B4 is not N/A. I've tried using formula below but not sure why it isn't working. =IF(AND($D4='ConditionRatings'!$A$1:$A$4),AND(COUNTBLANK($D1:$D5)>0)) E.g. If B4 is "1" then B1, B2...

Hi all, I need some help in using vba to get the last Letter/Word from a column while the values below it are set as "NA" E.g <tbody> 0A 1B NA NA NA NA NA </tbody> In this case, the value of 1B will be copied/stored. Thank you in advance!

Hi there, I'm confident with using Access but Excel is very new and confusing to me. I have been given 446818 ISBN numbers in a text file, some are 13 numbers long and some are 10 long. Where the information was pulled, some of the numbers had text after them e.g: (paperback). When the text...

Hi All, Could anyone teach me how to put a number (e.g. 1) in a cell, after enter it will show a word (e.g. apple / sweet apple) ? thanks a lot.

Is it possible to use conditional formatting to format a cell based on a date For example Cell A3 = 01/01/2018 - I require cell H3 to be red If cell B3 changes to another date E.g. 05/02/2018, I wish to change the colour of cell H3 to be green If cell C3 changes to another date E.g...

Hi, I'm working on an excel function after many years away and I have come a little unstuck. I understand the problem I am just struggling to find a solution to it and would appreciate any help anyone might be able to offer. The function is straightforward <code>...

Please can you help with this problem - See table below: I would like to put a formula in Colum C that adds up the total per person. So it needs to: a) find everyone with the same name in Column A (e.g. everyone called John) b) look in the corresponding row in Column B and add up all of those...

I have a series of numbers in a cells in a column e.g. 5632 4361 3343...