for first query try thi with CSE
=SMALL(IFERROR(IFERROR(SMALL(IF($C$5:$C$14<>$B$5:$B$14,$C$5:$C$14,""),ROW(INDIRECT("1:"&$C$5:$C$14))),IF($B$5:$B$11<>$C$5:$C$14,$B$5:$B$11,"")),""),ROW(INDIRECT("1:"&COUNTA($C$5:$C$14
and for second try this wit CSE
=SMALL(IF($C$5:$C$14<>$B$5:$B$14,$C$5:$C$14,"
Hello Rafael,
check the below sub and call the sub @ 'Need help here to do something with
the data collected from Sql Server
'
*
Private Sub WriteDate(rs As Recordset)
On Error GoTo ErrorMessage
Dear All:
Please see attach excel file and if you can help me with a formula to
generate OUTPUT in 2 different ways from List 1 and List 2.
*Thanks in advance!*
--
*Ahmed Bawazir*
*احمد باوزير*
--
*Ahmed Bawazir*
*احمد باوزير*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Hi Excel Expert,
I am Pramod. Any have idea that any kind of book available in market for
Web scrpting by excel vba
I am newly developer of excel vba. and also suggest me that can i use macro
recorder code in my real code. And give me suggest that how can i expert
in vba programming.
I will l
I am trying to determine the code that would (passively) record the users,
within our company, who are using a selected workbook.
Is this feasible and if so how do I write it.
Thank you,
Rob
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) !
Excel (2007) intermittently adds the full pathname of the add-in to the
function name when it's used in a cell formula. Then if the spreadsheet is
opened on another computer, even if the other computer has the add-in
installed, the function is not recognized. Any idea how to solve this?
Divaker
I have a database and want to populate data into cells from another sheet
in the same database in excel, any suggestion how I can go about this?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
http
Hi
you can do using combination of Index & Match function.
Thanks
On Tue, Mar 25, 2014 at 5:42 PM, Deepak Rawat wrote:
> Hi,
>
> is there any solution in someproduct formula to get intersect text value
> in 2D range:
>
> Below is the data;
>
>Bran Model - 1 Model - 2 Model - 3 Model - 4 A
i think you want
=VLOOKUP(B7,$A$1:$E$4,MATCH(C7,$A$1:$E$1,0))
On Tue, Mar 25, 2014 at 5:42 PM, Deepak Rawat wrote:
> Hi,
>
> is there any solution in someproduct formula to get intersect text value
> in 2D range:
>
> Below is the data;
>
>Bran Model - 1 Model - 2 Model - 3 Model - 4 Audi
Hi,
is there any solution in someproduct formula to get intersect text value in
2D range:
Below is the data;
Bran Model - 1 Model - 2 Model - 3 Model - 4 Audi A4 A6 A8 A10 BMW Series
3 Series 5 Series 7 X6 Mercedes A Class C Class E Class S Class Brand
Model Answer BMW Model - 2 Ser
Dear Team Members,
This is my first query to the group.
I have some excel files, when we i try opening, it says contact servers :
xyz...
and it goes on and on, some time it takes 10 to 15 minutes.
Just wanted to check how do i disable this
I use MS office 2013.
below is the screen shot fo
www.quickdatacleansing.com is an online data cleansing solution.
The need for data cleansing is made clear when considering how easily
errors can be made. In a database of names, addresses or contact numbers,
for example,
- Name might be entered as Bobby John¼23son.
- Address may be 143$2!^&a,
www.quickdatacleansing.com is an online data cleansing solution.
The need for data cleansing is made clear when considering how easily
errors can be made. In a database of names, addresses or contact numbers,
for example,
- Name might be entered as Bobby John23son
- Address may be 143$2!^&a,/
Thanx for your kind suggestion, i am trying to learn the VBA
On Tue, Mar 25, 2014 at 2:17 PM, Divaker Pandey wrote:
> need to use both procedure for your requirement, you were using only one.
>
> and please try to learn vba wtih programming skill.
>
> it will help you understand other's progra
14 matches
Mail list logo
