wondering

Hello all I used find() to find the location of the first space in the following text 123 main street and find() returned 4, so far so good. now i am wondering if i want to find the location of the second space in that text, what should i do? Thank you so much.

Hi Everyone I was wondering if anyone would know of a way I could get a macro to run when click on a pivot table splitter? I'm use a chart and need a macro called "chrt" to rum so the parameters are correct? I was wondering if there was a trigger in the sheet part of vba where you do the On...

Hello, Just wondering what is happening to the amount of users on this forum... when i first started using this there was a constant 3-4k users online almost all the time. Now im only seeing it barely hit 1k and i have been using it at the same time as i was before... I was just wondering...

Hello all. I was wondering if anyone else was having issues navigating the forum this morning Screenshot by Lightshot Thank you

<tbody> A1 Bob(B1) Mary (B2) Nina NINA (A4) </tbody> I'm wondering if there is a formula that is available that will search B1:B3 and if it matches A4 (NINA) it will then anything in Column B that matches to uppercase or to mirror A4. So I'd want it to then change it to look...

=IFERROR(VLOOKUP(A8,INDIRECT('COLLECTIONS '! '"&$N3&"'!"'&"$D:$V"),8,FALSE),0) This one does not work =IFERROR(VLOOKUP($C3,INDIRECT("'"&$N3&"'!"&"$D:$V"),8,FALSE),0) This one works fine I am trying to get the same data to pull into another sheet - is it not possible to have the indirect table...

Hi everybody, I asked my intern to solver a problem about trigonometry. However, the equation he developped work, but are incredibly long and complicated for nothing. I was wondering if there's was a way to shorten - simplify a excel equation. Here's is the equation .... ...

Hello I am just wondering if it possible to populate the listbox depending on what has been chosen for the combobox and if so, how would you go about doing it? Thanks

I have a sheet that needs to compare several (10) columns and approximately 20 rows of data they are not next to each other and I am currently trying to use '=MIN(IF((F7,P7,Z7,AJ7,AT7)<>0,(F7,P7,Z7,AJ7,AT7),"Nope")) it isn't working. I was wondering if named ranges would be better but I would...