wondering

I am wondering if its possible to have a VBA to convert a cell with multipule lines? I have a file that has 500+ cell that have multi-lines, so i am looking to have a costume vba where i can = to a cell. I have put an example what I want <tbody> Cell one 1 6 8 7 11 23 456 4 12 13 465 251...

Hi, I tried to post a new thread about 3 hours ago and nothing has come through. Just wondering if this is normal procedure and if a mod could please look into it Thanks

i was wondering if some one could help me with the following problem and thanks in advance <colgroup><col width="72" span="17" style="width:54pt"> </colgroup><tbody> TIME 20:00 21:00 22:00 23:00 00:00 01:00 02:00 03:00 04:00 05:00 06:00 07:00 08:00...

Hey I am using the below code to schedule runs of a macro. But I am worried that if there is some interruption to the scheduling, there will be a problematic delay before I pick up on it. So I'm wondering whether or not there is a way to check what and when macros have been scheduled if any...

Hello all, I'm hoping someone can help me out as I've searched everywhere to no avail! I'm having a couple of issues with what I'm trying to achieve, please see screenshot: https://www.dropbox.com/s/m5it3j5u8zuch5l/ScreenShot1.png?dl=0 1. I'm trying to have 2 x-axis, where I can place the...

Hi, Was wondering if anyone could take 5 minutes to review one of my spreadsheets. I have completed it to a good standard but was wondering if any one could provide feedback? It's not very complex so doesn't require a genius, although any help would be great! Thanks,

Hello, I am working on a big document. I got a formula that helps me with one column, but I am wondering if I can make this more user-friendly. This is the formula =IF(O7="","",IF(O6="","",IF(O7=O6,"","ERROR"))) I am wondering if there is a way if I edit a cell, let say b2 that the Bold O will...

I want to be able to bin my data set so I can get a histogram in 5% increments. i,e a bar chart that shows how many falls in the [-999%,-50%, ],[-50%,-45%), [-45, -40%),.......[+50%,+999%] Even in standard excel, I only know how to do this with a "CountIf" statement. However, this is...

Hi all I was wondering if anyone could help me out with a problem. I have about 1,500 word documents with tables that represent student evaluation. It is a tick box exercise where we have very good, good, needs work. I was wondering if it would be possible to make some VBA code that opens each...

Hello I have a dataset and I am trying to use a formula. However despite spening ages on it it still not working. I am new to this and am probably missing something pretty obvious, and I was wondering if someone could have a look at it to see if it is written incorrectly. =-1.675 + (0.037*e2)...

Hi all, I'm wondering if anyone can help with a formula:confused: In cell G3 I would like a total of column C, but only for X911/C (column B)

Hi, I am familiar with accessing the elements of a webpage using the CreateObject("InternetExplorer.Application"). I was wondering if there is a similar way to access the elements of Google Chrome and Firefox Mozilla ? Thanks.

This could be really simple... What is the best way (formula or other..) That would do a count of say "S" depending on the name of the person in "Cell x" on different sheets in the same work book. I was thinking a Vlookup/count if formula but just wondering the best way to contruct it. I...

dear experts, we know that excel will allow to overwrite the lateral neighbor cell i was wondering whether this is also possible in vertical direction ? Regards Desmond

Hello all, i have really quick question. Does anyone pls know, what means "k" in formulas in Excel? And I dont mean function of it, I know what it is and what it does...I would like to know, what word is hidden under the "k" shortcut... :-) I was trying to search everywhere and did not find...

I'm thinking this should be possible using the Application.Wait function, but I'm wondering how you get the input to close after resuming if there is no entry?

:confused:

Hi, There are many Android apps out there that track your comics/books/manga you have read. However I never quite found one that worked how I wanted it to or that tracked all 3 types of literature well. Therefore I built my own database in excel. So far it works pretty well for what I want but...

Hi there, I posted this on Reddit and a helpful user explained what needed to be done, still hasn't got back to me though... Was wondering if anyone on here could help? (Link Below) https://www.reddit.com/r/excel/comme...hese_on_a_new/

Hi I have simple table like the one below. I wanted to insert a bar chart. I am wondering if I can change the color of each individual chart to different color (not manually), I know if i click on any bar and then click again to select that bar only (lets say Mary's bar) then I can change the...