Excel helpp!!!!!!!
Watch
Announcements
Page 1 of 1
Skip to page:
Hi, i have some questions to ask about excel. Can you please get in touch! Ill be happy if you can help
Thanks
Thanks
0
reply
Report
#2
(Original post by HiItshannah)
Hi, i have some questions to ask about excel. Can you please get in touch! Ill be happy if you can help
Thanks
Hi, i have some questions to ask about excel. Can you please get in touch! Ill be happy if you can help
Thanks

0
reply
(Original post by Dapperblook22)
I used Excel in my AS Level ICT coursework last year, I might be able to remember a few things if you ask
I used Excel in my AS Level ICT coursework last year, I might be able to remember a few things if you ask

0
reply
Report
#4
(Original post by Dapperblook22)
I used Excel in my AS Level ICT coursework last year, I might be able to remember a few things if you ask
I used Excel in my AS Level ICT coursework last year, I might be able to remember a few things if you ask

--------------
to OP i have done some work with excel, post your problem so people can help you with it

0
reply
Report
#5
(Original post by fatima1998)
last year as in 2015? new coursework or you have done your A levels including A2?
--------------
to OP i have done some work with excel, post your problem so people can help you with it
last year as in 2015? new coursework or you have done your A levels including A2?
--------------
to OP i have done some work with excel, post your problem so people can help you with it

1
reply
Report
#6
(Original post by HiItshannah)
Hi, i have some questions to ask about excel. Can you please get in touch! Ill be happy if you can help
Thanks
Hi, i have some questions to ask about excel. Can you please get in touch! Ill be happy if you can help
Thanks

0
reply
Report
#7
(Original post by HiItshannah)
Hi, i have some questions to ask about excel. Can you please get in touch! Ill be happy if you can help
Thanks
Hi, i have some questions to ask about excel. Can you please get in touch! Ill be happy if you can help
Thanks
In any case, you really should post the question you're stuck on so that people can immediately see if they're able to help or not, otherwise people are just guessing whether they have the right level of knowledge

0
reply
Thanks for your advice !
But unfortunately I cant upload the file
it's basically use of Vlookups, trim,find and pivot tables etc.


0
reply
(Original post by davros)
You may get a better chance of a response if you post in one of the IT / computing forums.
In any case, you really should post the question you're stuck on so that people can immediately see if they're able to help or not, otherwise people are just guessing whether they have the right level of knowledge
You may get a better chance of a response if you post in one of the IT / computing forums.
In any case, you really should post the question you're stuck on so that people can immediately see if they're able to help or not, otherwise people are just guessing whether they have the right level of knowledge

- Thanks for your advice !
But unfortunately I cant upload the file
it's basically use of Vlookups, trim,find and pivot tables etc.
0
reply
Report
#10
(Original post by HiItshannah)
- Thanks for your advice !
But unfortunately I cant upload the file
it's basically use of Vlookups, trim,find and pivot tables etc.
Are you struggling to get started, or having problems getting a particular formula to work, or something else?
To be honest, Excel is one topic where there are literally thousands of online tutorials, support groups etc where you can find instructions, help etc.
If you have a specific question on any of the formulas / functions etc, just post it here and one of us will try to help

EDIT you can attach files to posts here! Or did you mean that you don't want to / aren't allowed to?
0
reply
(Original post by davros)
Difficult to give more help without knowing what you're trying to do!
Are you struggling to get started, or having problems getting a particular formula to work, or something else?
To be honest, Excel is one topic where there are literally thousands of online tutorials, support groups etc where you can find instructions, help etc.
If you have a specific question on any of the formulas / functions etc, just post it here and one of us will try to help
EDIT you can attach files to posts here! Or did you mean that you don't want to / aren't allowed to?
Difficult to give more help without knowing what you're trying to do!
Are you struggling to get started, or having problems getting a particular formula to work, or something else?
To be honest, Excel is one topic where there are literally thousands of online tutorials, support groups etc where you can find instructions, help etc.
If you have a specific question on any of the formulas / functions etc, just post it here and one of us will try to help

EDIT you can attach files to posts here! Or did you mean that you don't want to / aren't allowed to?
This is the formula ive got, cell B2 has texts and symbols such as |,_,(. questions sheet is a different sheet where i have to reference from. i need to compare the first part of the name in B2 with the references in questions sheet and if theyre equal, itll copy the cell in questions sheet (C6 in this case). but this formula doesnt work for _ and ( i get "value!" or "false"
0
reply
Report
#12
(Original post by HiItshannah)
=IF(TRIM(LEFT(B2, (FIND( {"|","_","("}, B2))- 1)) = Questions!$B$6, Questions!$C$6, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$7, Questions!$C$7, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$8, Questions!$C$8, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$9, Questions!$C$9, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$10, Questions!$C$10)))))
This is the formula ive got, cell B2 has texts and symbols such as |,_,(. questions sheet is a different sheet where i have to reference from. i need to compare the first part of the name in B2 with the references in questions sheet and if theyre equal, itll copy the cell in questions sheet (C6 in this case). but this formula doesnt work for _ and ( i get "value!" or "false"
=IF(TRIM(LEFT(B2, (FIND( {"|","_","("}, B2))- 1)) = Questions!$B$6, Questions!$C$6, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$7, Questions!$C$7, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$8, Questions!$C$8, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$9, Questions!$C$9, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$10, Questions!$C$10)))))
This is the formula ive got, cell B2 has texts and symbols such as |,_,(. questions sheet is a different sheet where i have to reference from. i need to compare the first part of the name in B2 with the references in questions sheet and if theyre equal, itll copy the cell in questions sheet (C6 in this case). but this formula doesnt work for _ and ( i get "value!" or "false"

In the absence of the file, what I would personally do first is check that the TRIM() part of the formula is actually returning what it's supposed to. The easiest way to do this is to put that part of the formula into a free cell somewhere and see what value it's returning. Does this make sense?

0
reply
Report
#13
(Original post by HiItshannah)
=IF(TRIM(LEFT(B2, (FIND( {"|","_","("}, B2))- 1)) = Questions!$B$6, Questions!$C$6, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$7, Questions!$C$7, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$8, Questions!$C$8, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$9, Questions!$C$9, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$10, Questions!$C$10)))))
...
=IF(TRIM(LEFT(B2, (FIND( {"|","_","("}, B2))- 1)) = Questions!$B$6, Questions!$C$6, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$7, Questions!$C$7, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$8, Questions!$C$8, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$9, Questions!$C$9, IF(TRIM(LEFT(B2, FIND({"|","_","("}, B2) - 1)) = Questions!$B$10, Questions!$C$10)))))
...
I've never seen FIND used like that before!
Unless this is a recent enhancement in Excel, I thought FIND could only search for a single substring within another string, not one of a number of strings within a larger string. Are you sure that syntax with the braces {} is supposed to work?
0
reply
X
Page 1 of 1
Skip to page:
Quick Reply
Back
to top
to top