orange

Hi, I am trying to move text up in a range when there is empty rows above or in between. I thought I had got it to work but I just found out a big problem, it clears and copies the wrong rows. Does anyone of you experts think you could help me out with this problem? Here is an example of the...

Hi all, I have a range of values (B2:B11) that have multiple Conditional Formatting (CF) rules, I am now trying to make a UDF that will count how many cells are orange for example. I have used the following procedure to decipher what the colour index is of the orange cell: Sub...

I have a bunch of bar charts that need to be updated monthly or quarterly. I would like a quick easy way to update all of the charts when new data is added automatically. The far right bar needs to be an orange color as it is not a complete amount for the time frame. An example would be we...

Here's an example: <tbody> John apple John fridge John heart John pear John car Steven soap Steven display Steven pen Steven orange Steven bee </tbody> I would like it to look like, <tbody> John apple fridge heart pear Car Steven soap display pen orange bee...

Hi I wanted a formula and conditioning formatting for 3 conditions, If training is past expiry date to go red and say expired, If not due stay green and say not due. if 30 days or less to go say - 30 day or less and turn orange. Thanks in advance and any help will be appreciated.

I am trying to identify duplication of words between cells and am hoping this can be accomplished with VBA Here is a sample of the input and output. I am comparing string 1 to string 2. String 1 String 2 Output red orange yellow green...

Hi Team, I am looking some help on creating a macro which could help me sum values in column for B for similar text in col A and insert the sum field in col b for after every group its sums up and also insert a blank row after its sum the data <tbody> Names Value Apple 25 Apple 10...

Would very much appreciate assistance with the following. I have a long list of data most of which is separated into blocks of 6 with a blank row in between. Occasionally, I encounter a block of 5 and I would like to insert a row after item 5. 1 Blue 2 Green 3 Orange 4 Red 5 Brown 6 Black...

I’m using these two formulas to sum the data in the appropriatecells: =SUMIF($C$4:$C$200,"ORANGE",D$4:D$200) =SUMIF($C$4:$C$200,"BLUE",D$4:D$200) Both work perfectly. Now I need a formula that will sum thetotal if instead of looking specifically for ORANGE or BLUE, it looks for GREENor...

The following is the code I have for moving the blank rows located throughout a table in Excel. When I run the code, it is only moving the 1st and 3rd column blanks down. I have 7 total columns. Any help on this would be much appreciated. Public Sub main() Dim oRange As Range Set oRange...

Hi all, I am not Excel proficient so sorry if this is a dumb question. I’ve spent over an hour trying to find help on Google. Im trying to create a table with the same data in the column and row headers to show possible combinations and the results that they created. I also need each new...

Hi all Master, I'm really confused to grab TEXT from words, i already trying used many formula but still <tbody> No. EXAMPLE OF DATA 1 <tbody> XXXXXXX XXXXXXX: 111111_CCCCCCC {SITE NO_111111_BLUE CAR DAYS, SITE NO_111111_RED HOT MOON, SITE NO_111111_THUNDER STORM, SITE NO_111111_GUN...

Hi, I will try and make this all make sense.... I have a spreadsheet with 3 work sheets, A,B,C for ease sheet A is master, in which I have columns A - K, Column B has a ref number, this ref number is also in Sheet C on sheet A in column I, I have a drop down list of Y, N, U which I have set...

Hi I have a spreadsheet that has different colours in. I need to be able to count all blank orange cells within a certain range. Countblank doesn't work, so I thought of perhaps using countccolor as I can get it to count all the orange cells but then I don't know what to add to it to count...

Hi everyone..pleasure to meet..I would like to ask 2 questions.. How to create auto numbering in excel and restart on new items. Like the example below: <thead> Data Automatic number Red 1 </thead><tbody> Red 2 Red 3 Blue 1 Blue 2 </tbody> 2. Is there...

Hi friends, i have in cell A1= 4001 A2= Jhon A3= Orange how to get the value of Orange(A3) if i have the value: 4001 (A1) Thanks

Hi I am currently trying to create a formula to count the number of cells of a certain colour that is a certain criteria. I'm looking for something like a countcolorif function but can't work it out and I'm getting frustrated that I can't work this out! Basic version below of spreadsheet...

Hi, coming back after a long time:) coz i need your help very badly. I have 2 columns like below, I simply need to to transpose these data into columns in a new sheet List 1 List 2 Apple Boomerang Apple Offerings Apple Industrial Equipment Apple Chemicals & Natural Resources Apple Consumer...

I have data that is consolidated into single cells. I'd like to alphabetize the strings within the cells they are in: <tbody> Original Data Alphabetized Data Orange,Apple,Banana Apple,Banana,Orange Grape,Apple,Grape,Banana Apple,Grape,Grape,Banana Grape Grape Apple,Orange Apple,Orange...

Hello All, I will need help with below tables calculation... There are huge datas all the way down from column A. So if its possible I need to place formulas to get proper calculatin base on given table below starts from column J Many Thanks...