-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
none;
-
A
Move rows to sheet based if row contains certain string value
Hi all Wondering if you could help. I have seen other older threads here but couldn't get them to work for me. I have a bank statement I am importing via CSV into Excel. Example data (Sheet 1) is in the following format: <colgroup><col><col><col><col></colgroup><tbody> Date Description...- aaelex
- Thread
- 1px; charge move none; sheet
- Replies: 10
- Forum: Excel Questions
-
T
Pasting Text Changes sheet font
Hello, Is there a way so that when I copy text from another source and paste it into excel it wont change the font. I know I can do paste special and then quick on text and it will be fine but is there a quicker way perhaps with a formula? I am using Calibri (Body) 12. Any help would be...- thescream80
- Thread
- 1px; none; paste text vertical-align
- Replies: 1
- Forum: Excel Questions
-
D
Formula to implement a regression equation
I created a scatter chart of some data and the equation returned was: <tbody> <tbody> y = 7E-24x[SUP]12.666 </tbody> <style>table { }.font5 { color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri...- dross
- Thread
- 1px; color equation formula none;
- Replies: 3
- Forum: Excel Questions
-
W
Problem with Auto Incrementing Text String
Hi All I am having difficulties with creating a formula to deal with the following:- I am trying to autoincrement the last character (1, 2 or 3 characters) of a text string. The problem is the string could be different lengths and needs to autoincrement from whatever the last number is from...- WednesdayC
- Thread
- 1px; cell color none; string
- Replies: 24
- Forum: Excel Questions
-
D
Help in removing multiple random amounts of periods
I need help in removing periods from a series of cells. Example: <colgroup><col style="mso-width-source:userset;mso-width-alt:8618;width:202pt" width="202"> </colgroup><tbody> Columbia-Barnard......................... Duke...- DougStroud
- Thread
- 1px; none; periods removing vertical-align
- Replies: 5
- Forum: Excel Questions
-
W
Formula to Sum Cells when value changes in another Column
Hi All I found the following formula which almost gives the results I require:- <style>table { }.font5 { color: black; font-size: 9pt; font-weight: 700; font-style: normal; text-decoration: none; font-family: Arial, serif; }.font6 { color: black; font-size: 9pt; font-weight: 400...- WednesdayC
- Thread
- font-family font-size font-weight none; text-decoration
- Replies: 6
- Forum: Excel Questions
-
W
Why doesn't this formula work? function works seperately but not as part of a bigger function.
Hello, thanks for considering helping me with this. I have this function: =IF(OR(A2={"-1",-2}),5,IF(AND(A2>10),X2*0.9,IF(AND(10>=A2>=3),A2-1,IF(AND(3>A2),((A2-1)/2*0.1667+0.5)*A2)))) Some of the parts are just there because I don't know how to correctly trim down a function someone helped me...- Waboku
- Thread
- 1px; function none; results returns
- Replies: 3
- Forum: Excel Questions
-
N
Swap cells on Sheet 1 to swap columns on Sheet 2
Hello, I am naveed, this is the first time ever i am writing on a web portal for help. I hope this works out, below mentioned is my query. 1. Imagine below is the data that we have in Sheet 1 <style>table { }td { padding: 0px; color: black; font-size: 12pt; font-weight: 400; font-style...- Naveed7991
- Thread
- border none; solid text-align windowtext;
- Replies: 3
- Forum: Excel Questions
-
I
vba contorl html get data
How can i use vba get the data 111111 into excel cell A1, Thanks you.- IORI YAGAMI
- Thread
- div none; style=display thead vba
- Replies: 0
- Forum: Excel Questions
